ORA-7445 [kxsciraddcursorresult] Occurs When DBMS_SQL.RETURN_RESULT is Used in a Scheduler Job (Doc ID 2801891.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Using DBMS_SQL.RETURN_RESULT() in PLSQL code that is invoked via DBMS_SCHEDULER could hit an ORA-7445 [kxscirAddCursorResult] error. While the code itself returns to the SQL*Plus prompt successfully, the ORA-7445 [kxscirAddCursorResult] is written to the database alert log. A simple example is:

 Note that if the second parameter of DBMS_SQL.RETURN_RESULT is set to true (i.e. to_client=>TRUE), then an ORA-29481 "Implicit results cannot be returned to client" error is written to the alert log when DBMS_SCHEDULER.CREATE_JOB is run instead of ORA-7445 [kxscirAddCursorResult].

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.