Postgres Stored Procedures returing cursor

Hi

I have written a Postgres stored procedure to return a cursor. I have created a dataset as SQL Stored Procedure Query. But it returns only the cursor name instead of resultset.

My query is as follows:
select fn_list_users(param1,param2);

It returns a refcursor.

normally i used to run the query manually in postgres as follows

select fn_list_users(param1,param2);
fetch all in "<unnamed portal 1>"

But I couldn't give the two statements in the Stored Procedure Query BIRT.

Can anyone help in this regard.

Thanks in advance
Sangaran

Find more posts tagged with

Comments

Tianli

Why not to use {call fn_list_users(?,?)}

sangaran

if I do call like this {call fn_list_users(?,?)}

It is returning as output column as "<unnamed portal 1>" instead of result set.

Actually that is the cursor name.

I need to use FETCH ALL IN "<unnamed portal 1>", but i can't use both in that query window