Oracle Packages and Stored Procedures - PostgreSQL conversion

From: Panneerselvam Posangu <panneerpps(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Oracle Packages and Stored Procedures - PostgreSQL conversion
Date: 2013-06-11 05:41:06
Message-ID: COL126-W198C2D9388456BE349A55CDF850@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 PackagesIs it advisable to convert constituent stored procedures into PostgreSQL Functions and wrap them inside another function?
2. PL/SQL Stored ProceduresIs 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-06-11 06:35:05 Re: Oracle Packages and Stored Procedures - PostgreSQL conversion
Previous Message Raghavendra 2013-06-11 05:37:50 Re: updatable view