Technology Stack - EBS (MOSC)

MOSC Banner

Ref Cursor query raises two task error

edited Aug 20, 2021 10:49AM in Technology Stack - EBS (MOSC) 1 commentAnswered
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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center