ORA-1004 DBMS_SCHEDULER.RUN_JOB USE_CURRENT_SESSION=FALSE
(Doc ID 456808.1)
Last updated on APRIL 06, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
A 10.2.0.1.0 database has a public anonymous link used to connect to 9.2 database.
A PLSQL procedure name of "<procedure_name_switch_dblink>" is used for switching of public/private database links from one instance to another in a replicated environment.
When running this procedure with DBMS_SCHEDULER, it errors with:
ERROR at line 1:
ORA-01004: default username feature not supported; logon denied
ORA-02063: preceding line from <anonymous_dblink_name>
While executing the procedure by itself, no errors are seen.
While executing the RUN_JOB through SQLPLUS session, no errors are seen
If the job is scheduled via DBMS_SCHEDULER.RUN_JOB, it generates the ORA-1004 error.
--Manually executing exec <procedure_name_switch_dblink> runs without errors with users SYS and SYSTEM
--Manually executing the job through dbms_scheduler.run_job runs without errors with users SYS and SYSTEM
--Running through the scheduler, errors with ORA-1004
--Manually executing the job through dbms_scheduler.run_job with use_current_session => false errors with ORA-1004
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