Hi everybody
I defined a function returning refcursor.
CREATE FUNCTION cursorname (refcursor, character varying, character
varying) RETURNS refcursor ...
which does a select with username and serachphrase.
If I call
BEGIN;
SELECT cursorname(`test`,`username`,`searchphrase`);
MOVE 10 in test;
FETCH 25 from test;
COMMIT;
inside psql everything works well. If I put this code into a
scriptfile and call it, I get the following errormessage:
cannot handle multiple result groups
Why? What does this mean?
I use a webserver which has 'one' persistent connection to the
database. Executing the script the connection breaks. Trying to do a
rollback the database returns that there is no transaction in
progress.
Any help is welcome
Regards
Conni
