X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7BB96D1B486 for ; Mon, 22 Dec 2003 10:31:32 +0000 (GMT) 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 90274-04 for ; Mon, 22 Dec 2003 06:30:44 -0400 (AST) Received: from web41006.mail.yahoo.com (web41006.mail.yahoo.com [66.218.93.5]) by svr1.postgresql.org (Postfix) with SMTP id CED90D1B477 for ; Mon, 22 Dec 2003 06:30:41 -0400 (AST) Message-ID: <20031222103043.50050.qmail@web41006.mail.yahoo.com> Received: from [61.11.83.253] by web41006.mail.yahoo.com via HTTP; Mon, 22 Dec 2003 02:30:43 PST Date: Mon, 22 Dec 2003 02:30:43 -0800 (PST) From: sundaresan raman To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=4.2 tagged_above=0.0 required=5.0 tests=BAYES_30, RCVD_IN_DSBL, RCVD_IN_NJABL X-Spam-Level: **** X-Archive-Number: 200312/154 X-Sequence-Number: 16320 hi, I am new of postgre sql.im using cursors in pgsql and getting tuples successfully returns in c++, but how can i raise exception in the stored function?.pl anyone help me. This is my function : CREATE or REPLACE FUNCTION sp_test_validatePartnerCode(text) RETURNS int4 AS ' DECLARE t_p_code ALIAS FOR $1; curPartner CURSOR FOR SELECT partner_code FROM test_license WHERE partner_code = t_p_code; BEGIN OPEN curPartner; return curPartner; END; 'LANGUAGE 'plpgsql' ; advance thanks , sundar __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/