X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 75891D1EFCC for ; Mon, 3 May 2004 17:00:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 20276-05 for ; Mon, 3 May 2004 17:00:36 -0300 (ADT) Received: from wolverine.lercnetworks.com (sabertooth.lercnetworks.com [140.99.13.90]) by svr1.postgresql.org (Postfix) with ESMTP id E1B9FD1EFC7 for ; Mon, 3 May 2004 17:00:29 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) (uid 510) by wolverine.lercnetworks.com with local; Mon, 03 May 2004 13:40:13 -0400 From: "Dennis" To: "postgres SQL" Subject: returning multiple values and ref cursors Date: Mon, 03 May 2004 13:40:13 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8" Content-Transfer-Encoding: 7bit Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/17 X-Sequence-Number: 17731 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