Horton

Re: DECLARE CURSOR

Frank Miles <fpm@u.washington.edu>

View thread
From: Frank Miles <fpm@u.washington.edu>
To: snpe <snpe@snpe.co.yu>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2002-11-16T21:29:25Z
Lists: pgsql-hackers 
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