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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
