Link to home
Start Free TrialLog in
Avatar of tesmc
tesmcFlag for United States of America

asked on

Select error: ORA-24334: no descriptor for this position

i have a window that upon open() retrieves data from a sql for a datawindow.
This retrieval returns about 500 records.
I also have a function call in the retrieverow() event which cursors through another table and obtains data to be concatenated based on the ID from the datawindow's resultset.
But i get the following:

Select error: ORA-24334: no descriptor for this position

i think , it might have something to do with the fact that the transaction object sqlca connection is still trying to finish the SQL the datawindow executed, while i'm trying to loops.

i tried creating a new transaction object for the cursor - but that didn't resolve the error message.

the dw is using sqlca and so is the cursor.
how do i create a new transaction object specific to the cursor -so that it won't crash ?

thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of diasroshan
diasroshan
Flag of Kuwait image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi,

i also suggest an alternative...
once the entire 500 rows are retrieved then loop thru them using a cursor n concatenate the desired values.

Cheers,
Rosh
Forced accept.

Computer101
EE Admin