PLS-00455: cursor 'string' cannot be used in dynamic SQL
OPEN statement



PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement..

Answer / guest

Cause: dynamicly OPEN a REF CURSOR that has RETURN type.
However, only REF CURSOR without RETURN type can be OPEN'ed
by an embebded dynamic OPEN statement.

Action: define a REF CURSOR without return type, and use it
in the statement.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01319: Invalid Logminer session attribute

1 Answers  


ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

1 Answers  


LFI-00146: copy does not expect the file string.string to exist

1 Answers  


NPL-00305: unsupported ASN.1 "UNIV" type string

1 Answers  


PCC-02133: CMD-LINE: Error in string processing function

1 Answers  


ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

1 Answers  


PLS-00526: A MAP or ORDER function is required for comparing objects in PL/SQL.

1 Answers  


ORA-09936: Open of ORACLE password file for write failed.

1 Answers  


PCC-00105: Keyword WORK required here by ANSI

1 Answers  


NNL-00540: [show] status [<server_list>] : display server status summary

1 Answers  


SQL*Loader-00469: SID directive expects 1 argument, number found.

1 Answers  


ORA-29820: the statistics type is not present

1 Answers  


Categories