Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER END_DATE Null

user1849Jul 5 2022

Hi All
I have a Job running in Production and want to update END_DATE as NULL
I tried below command and giving error
begin
dbms_scheduler.set_attribute (
name => 'MY_JOB',
attribute => 'END_DATE',
value => null);
end;
Error report:
ORA-06550: line 2, column 1:
PLS-00307: too many declarations of 'SET_ATTRIBUTE' match this call
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

Thanks for your help

Comments
Post Details
Added on Jul 5 2022
3 comments
502 views