Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.