Oracle Packages and Stored Procedures - PostgreSQL conversion

Поиск
Список
Период
Сортировка
От Panneerselvam Posangu
Тема Oracle Packages and Stored Procedures - PostgreSQL conversion
Дата
Msg-id COL126-W198C2D9388456BE349A55CDF850@phx.gbl
обсуждение исходный текст
Ответы Re: Oracle Packages and Stored Procedures - PostgreSQL conversion  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Hi,

I have some Oracle Packages and some standalone procedure in Oracle schema. As we are converting our application as PostgreSQL compliant we are looking at these Oracle objects. These packages have no variables declared and consist of a few stored procedures. Please suggest a good approach to convert them into PosgreSQL compliant objects

1. PL/SQL Packages
Is it advisable to convert constituent stored procedures into PostgreSQL Functions and wrap them inside another function?

2. PL/SQL Stored Procedures
Is it advisable to convert stored procedures into PostgreSQL Functions?

I am quite new to PostgreSQL; hence seeking some help from larger group of experts. Currently I try to understand the suggestions from 9.2.4 documentation here: http://www.postgresql.org/docs/9.2/static/plpgsql-porting.html

Thanks in advance,
Panneerselvam Posangu

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: databse version
Следующее
От: Raghavendra
Дата:
Сообщение: Re: updatable view