PLS-00455

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

Causa: A REF CURSOR was dynamically opened that has RETURN type. However, only REF CURSOR without RETURN type can be opened by an embedded dynamic OPEN statement.

Acción: define a REF CURSOR without return type, and use it in the statement.