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 1AE18D1F0F6 for ; Tue, 4 May 2004 14:49:57 -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 79214-02 for ; Tue, 4 May 2004 14:49:30 -0300 (ADT) Received: from wolverine.lercnetworks.com (sabertooth.lercnetworks.com [140.99.13.90]) by svr1.postgresql.org (Postfix) with ESMTP id AA01ED1F09B for ; Tue, 4 May 2004 14:49:17 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) (uid 510) by wolverine.lercnetworks.com with local; Tue, 04 May 2004 11:28:48 -0400 References: In-Reply-To: From: "Dennis" To: "postgres SQL" Subject: Re: returning multiple values and ref cursors Date: Tue, 04 May 2004 11:28:48 -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/44 X-Sequence-Number: 17758 Dennis writes: > 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? I guess another question here is whether I can return a row type or record type with (integer, varchar, refcursor) and then make use of the refcursor from JDBC. I'm not the one doing the Java development on this project and its been a while since I've used JDBC. Tom, Bruce, I still owe you guys a test program that gives the error where it looks like the temp schema for the connection is getting destroyed before the connection is closed. Dennis