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-06311: IPA: Maximum number of servers reached

1 Answers  


ORA-02361: error while attempting to allocate number bytes of memory

1 Answers  


LSX-00102: duplicate element "~S"

1 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  


PLS-00425: in SQL, function argument and return types must be SQL type

1 Answers  






TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange

1 Answers  


ORA-23608: invalid resolution column "string"

1 Answers  


ORA-23430: argument "string" cannot be NULL or empty string

2 Answers  


SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

1 Answers  


ORA-22276: invalid locator for LOB buffering

1 Answers  


PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

1 Answers  


ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 Answers  


Categories