On Fri, 15 Nov 2002, snpe wrote:
> Hello,
> When I call DECLARE CURSOR out of transaction command success,
> but cursor is not created
> Reference manual say that this get error :
> ERROR: DECLARE CURSOR may only be used in begin/end transaction blocks
> I don't find this text in pgsql source code
> What is problem ?
According to the documentation for DECLARE CURSOR (v.7.2.x):
"Cursors are only available in transactions. Use to BEGIN, COMMIT and
ROLLBACK to define a transaction block."
This seems consistent with your error message. Please try
wrapping your DECLARE inside a transaction using BEGIN,...
HTH--
-frank