PLS-00455: cursor string cannot be used in dynamic SQL OPEN statement

PLS-00455: cursor string cannot be used in dynamic SQL OPEN statement

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.

No comments:

Post a Comment