returning multiple values and ref cursors

From: "Dennis" <pg-user(at)calico-consulting(dot)com>
To: "postgres SQL" <pgsql-sql(at)postgresql(dot)org>
Subject: returning multiple values and ref cursors
Date: 2004-05-03 17:40:13
Message-ID: courier.409683FD.000070AD@wolverine.lercnetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hello,

I am porting an Oracle stored procedure to plpgsql (pg 7.4.1) that has about
ten ref cursor OUT parameters, a varchar OUT parameter and returns an
integer. The varchar is an error/status message, the integer is a 1/0 for
success/failure.

What are your thoughts on the best way to approach this? Break up the stored
proc into ten different stored procs that return ref cursors?

Thanks,

Dennis
dennis at calico dash consulting dot com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2004-05-03 17:55:56 Re: [SPAM] Re: Permissions not working
Previous Message Arne Stoelck 2004-05-03 15:36:51 Re: \D TO FILE