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-02755: osnfsmcre: cannot create chared memory file ?/dbs/ftt_<pid>.dbf

1 Answers  


ORA-12011: execution of string jobs failed

1 Answers  


ORA-27002: function called with invalid device structure

1 Answers  


TNS-01180: Missing listener object string in Directory Server

1 Answers  


ORA-07266: sppst: invalid process number passed to sppst.

1 Answers  






ORA-00311: cannot read header from archived log

1 Answers  


ORA-12093: invalid interim table "string"."string"

2 Answers  


ORA-16583: bad Data Guard Connection Process DRCX state

1 Answers  


RMAN-06157: validation failed for archived log

1 Answers  


LPX-00119: element "~1S" attribute "~2S" must be an unparsed entity

1 Answers  


PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

1 Answers  


DRG-10302: interrupted waiting for responses from servers

1 Answers  


Categories