Re: Problem calling stored procedure

From: <neil(dot)saunders(at)accenture(dot)com>
To: <neil(dot)saunders(at)accenture(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem calling stored procedure
Date: 2005-08-23 16:16:52
Message-ID: B74B7433CDDD2C4AA41D94832E32E19D92EE97@EMEXM1112.dir.svc.accenture.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Just a quick addendum;

I'm finding the number of rows by using GET DIAGNOSTICS num_entries = ROW_COUNT after I open the query, and then branching depending on this value - Is there any issue with using this in conjunction with cursors and OPEN FOR SELECT? I've just tried using OPEN FOR EXECUTE and quoting the query string, but still no luck - num_entries is still 0.

Thanks again,

Neil.

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Browse pgsql-sql by date

  From Date Subject
Next Message neil.saunders 2005-08-23 19:59:29 Re: Problem calling stored procedure
Previous Message neil.saunders 2005-08-23 15:25:19 Re: Problem calling stored procedure