CosmicNerd
Technical User
We are using Oracle ref cursors returned from a pl/sql package to return the record set to cognos.
The problem that we are experiencing is that on some cases Cognos return data from the ref cursor and in other cases we receive the error message listed at the end.
From an Oracle perspective the ref cursor is being generated correctly as the sql passed in to ref cursor has been executed correctly using sqlplus & the Oracle package has been executed as a stand alone within sqlplus.
Is it possible to use Oracle packages returning ref_cursors within reportnet?
What other methods are available where the report is generated as a back end Oracle packaage?
--------------
ERROR MESSAGE START
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0283 Metadata describing "Prob1" does not match results from the database.
RSV-SRV-0025 Unable to execute this request.
Acestar Solutions Limited
Cognos development and on-site training
The problem that we are experiencing is that on some cases Cognos return data from the ref cursor and in other cases we receive the error message listed at the end.
From an Oracle perspective the ref cursor is being generated correctly as the sql passed in to ref cursor has been executed correctly using sqlplus & the Oracle package has been executed as a stand alone within sqlplus.
Is it possible to use Oracle packages returning ref_cursors within reportnet?
What other methods are available where the report is generated as a back end Oracle packaage?
--------------
ERROR MESSAGE START
UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.
UDA-SQL-0283 Metadata describing "Prob1" does not match results from the database.
RSV-SRV-0025 Unable to execute this request.
Acestar Solutions Limited
Cognos development and on-site training