My Oracle Support Banner

ORA-12012 / PLS-00225: Subprogram Or Cursor 'XYZ' Reference Is Out Of Scope (Doc ID 1504495.1)

Last updated on AUGUST 29, 2017

Applies to:

PL/SQL - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Database job fails (ORA-12012) because of PLS-00225

Example of a job:


dbms_scheduler.create_job('"MYJOB"',
job_type=>'PLSQL_BLOCK', job_action=>
'begin schemaname.proc; end;'
, number_of_arguments=>0,
start_date=> ...);

 

Example of error stack:


ORA-12012: error on auto execute of job "SCHEMANAME"."PROC"
ORA-06550: line 1, column 761:
PLS-00225: subprogram or cursor 'SCHEMANAME' reference is out of scope
ORA-06550: line 1, column 756:
PL/SQL: Statement ignored

Changes

 if the job worked previously and suddenly started failing, then a new object was created.

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
Changes
Cause
Solution


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