Re: [GENERAL] return X number of refcursors from a function

2008-12-31 Thread Albe Laurenz
Derek Liang wrote: I tried to use the following code to retrieve the content of table1 4 times (in my application, the total number of refcursors that will be returned is determined by the data in the database). I am getting the error message says ERROR: cursor unnamed portal 2 already in

[GENERAL] return X number of refcursors from a function

2008-12-30 Thread Derek Liang
I tried to use the following code to retrieve the content of table1 4 times (in my application, the total number of refcursors that will be returned is determined by the data in the database). I am getting the error message says ERROR: cursor unnamed portal 2 already in use. Thank you in