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

DRG-10829: feedback id string is longer than the maximum length of string bytes

1 Answers  


ORA-16613: initialization in progress for site

1 Answers  


ORA-24043: destination string uses a reserved name, names with AQ$_ prefix are not valid

1 Answers  


ORA-02176: invalid option for CREATE ROLLBACK SEGMENT

1 Answers  


ORA-14518: partition contains rows corresponding to values being dropped

1 Answers  






ORA-36270: (XSCGMDLAGG03) The right-hand side of the AGGREGATION function includes duplicate values.

1 Answers  


ORA-10656: Table is unusable due to incomplete operation

1 Answers  


ORA-08451: invalid specification of DB in picture mask

1 Answers  


ORA-01550: cannot drop system tablespace

1 Answers  


PLS-00112: end-of-line in quoted identifier

1 Answers  


ORA-22628: OCIAnyData already constructed

1 Answers  


ORA-16215: history metadata inconsistency

1 Answers  


Categories