Oracle Error Message
PLS-00455: cursor ‘string’ cannot be used in dynamic SQL OPEN statement
Reason for the Error
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.
Solution
define a REF CURSOR without return type, and use it in the statement.
