Re: [GENERAL] Fwd: Need help in porting Oracle PL/SQL's OUT paramater based procedures

Removed -hackers from the mailing-lists. Just noticed it, and I think this is probably fine on the general list. Gurjeet Singh wrote: > On Thu, Feb 12, 2009 at 6:18 PM, Richard Huxton wrote: >> CREATE OR REPLACE FUNCTION f1(IN a integer, INOUT b integer, OUT c >> integer) RETURNS RECORD AS $$ >

Re: [GENERAL] Fwd: Need help in porting Oracle PL/SQL's OUT paramater based procedures

On Thu, Feb 12, 2009 at 6:18 PM, Richard Huxton wrote: > Gurjeet Singh wrote: > > that is, not passing anything for the OUT or INOUT parameters. This works > > fine for a simple SELECT usage, but does not play well when this function > is > > to be called from another function, (and assuming that

Re: [GENERAL] Fwd: Need help in porting Oracle PL/SQL's OUT paramater based procedures

Gurjeet Singh wrote: > that is, not passing anything for the OUT or INOUT parameters. This works > fine for a simple SELECT usage, but does not play well when this function is > to be called from another function, (and assuming that it'd break the > application code too, which uses Oracle syntax of

[GENERAL] Fwd: Need help in porting Oracle PL/SQL's OUT paramater based procedures

(forgot to include general list earlier) Hi All, I am involved in porting Spacewalk 's backend DB schema from Oracle to Postgres. We are almost done with table migration, and are now attempting procedure/function porting. A few things have been sorted out