My Oracle Support Banner

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

Last updated on JUNE 27, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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