alexk23
asked on
DBMS.REMOVE question
Hello, I am trying to remove DBMS_JOB, but getting error. My DBA is on vocation so I really stuck here.
Here is what I run:
SQL> select job from dba_jobs;
JOB
----------
1
2
3
Then I run:
SQL> execute dbms.remove(3);
BEGIN dbms.remove(3); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS.REMOVE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Please help!
Here is what I run:
SQL> select job from dba_jobs;
JOB
----------
1
2
3
Then I run:
SQL> execute dbms.remove(3);
BEGIN dbms.remove(3); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS.REMOVE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Please help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER