One more question.
I've created function converting setof to refcursor
CREATE OR REPLACE FUNCTION chasdb.getresult(...)
RETURNS refcursor AS
$BODY$
DECLARE
cur1 refcursor := 'result';
BEGIN
RAISE NOTICE 'string=%',biospanval_txt;
OPEN cur1 FOR execute('select * from
chasdb.getoverlapcounts('||....)||')'); -- returns setof
RETURN cur1;
END;
$BODY$
in pgAdmin everything is ok :
select
chasdb.getresult(ARRAY['chr5:12017264,17602802','chr5:45099457,46383335'],
'loh', 'loh', 'experiment', 'hg19');
fetch all in result;
returns suitable results;
In Java I've got an error
Caused by: org.jooq.exception.DataAccessException: SQL [select * from
chasdb.getresult(ARRAY['chr5:12017264,17602802','chr5:45099457,46383335'],
'loh', 'loh', 'experiment', 'hg19')]; ERROR: cursor "result" does not exist
Is it autocommit issue or I should fetch in some special case?
>
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
