#include <stdlib.h>
#include <string.h>


int
main (void)
{
exec sql begin declare section;
	int c;
exec sql end declare section;

	char msg[128];

	ECPGdebug(1, stderr);

	strcpy(msg, "connect");
	exec sql connect to postgres as test1;

	EXEC SQL PREPARE cur_query FROM "DECLARE cur1 CURSOR WITH HOLD FOR SELECT count(*) FROM pg_class";
	EXEC SQL PREPARE fetch_stmt FROM "FETCH next FROM cur1";
	EXEC SQL EXECUTE cur_query;
	EXEC SQL EXECUTE fetch_stmt INTO :c;
	fprintf(stdout, "count: %d\n", c);

	EXEC SQL CLOSE cur1;
	EXEC SQL DISCONNECT all;
	return 0;
}