Ref Cursor query raises two task error
Hi,
I had a ref cursor construct working just fine in an Oracle form (version 6i) used within Oracle Applications 11i.
We recently upgraded to Oracle Applications version R12 which uses the Oracle forms version 10i.
The original setup is as follows:
Database package builds the dynamic Sql string. A ref cursor variable (in out variable) is declared within the package. Then the ref cursor is opened.
Then, within the forms' program unit, the cursor is looped through to fetch the values.
With this setup, when a user tries to execute a search using the form, a two-task error is returned-error code of ORA-2063.
I had a ref cursor construct working just fine in an Oracle form (version 6i) used within Oracle Applications 11i.
We recently upgraded to Oracle Applications version R12 which uses the Oracle forms version 10i.
The original setup is as follows:
Database package builds the dynamic Sql string. A ref cursor variable (in out variable) is declared within the package. Then the ref cursor is opened.
Then, within the forms' program unit, the cursor is looped through to fetch the values.
With this setup, when a user tries to execute a search using the form, a two-task error is returned-error code of ORA-2063.
Tagged:
0