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-06040: NETDNT: invalid login (connect) string

1 Answers  


NZE-29108: Cannot initialize random object.

1 Answers  


ORA-23346: primary key or object ID is undefined for table or materialized view string

1 Answers  


ORA-09933: Deletion of old password file failed.

1 Answers  


ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

1 Answers  






TNS-12524: TNS:listener could not resolve HANDLER_NAME given in connect descriptor

1 Answers  


ORA-02037: uninitialized speed bind storage

1 Answers  


DRG-10843: invalid WEIGHT argument supplied to FUZZY

1 Answers  


NNL-00259: Server-generated requests now require authoritative answers

1 Answers  


ORA-30361: unrecognized string type

1 Answers  


ORA-01010: invalid OCI operation

1 Answers  


TNS-01067: Service display mode is string

1 Answers  


Categories