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-25443: duplicate column value for table alias: string, column number: string

1 Answers  


ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.

1 Answers  


ORA-02427: create view failed

1 Answers  


ORA-07492: scgrcl: cannot close lock.

1 Answers  


ORA-08209: scngrs: SCN not yet initialized

1 Answers  






IMG-00547: invalid channelOrder specified

1 Answers  


ORA-26680: object type not supported

1 Answers  


ORA-12918: Invalid tablespace type for default permanent tablespace

1 Answers  


RMAN-08085: created script string

1 Answers  


DRG-11100: unable to connect to the database

1 Answers  


ORA-07628: smsfre: sga not mapped

1 Answers  


ORA-12548: TNS:incomplete read or write

1 Answers  


Categories