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 "" already in > use". > >

[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 "" already in use". Thank you in advance! dl --Star