This is a discussion on DBMS_SCHEDULER.CREATE_JOB within the Oracle Miscellaneous forums, part of the Oracle Database category; --> what could be the error... SQL> begin 2 DBMS_SCHEDULER.CREATE_JOB ( 3 job_name =>'create_dir_test', 4 job_type =>'executable', 5 job_action => ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| what could be the error... SQL> begin 2 DBMS_SCHEDULER.CREATE_JOB ( 3 job_name =>'create_dir_test', 4 job_type =>'executable', 5 job_action => 'c:\winnt\system32\cmd.exe /c mkdir c:\test\test1', 6 enabled =>true,auto_drop => true 7 ); 8 commit; 9 end; 10 / DBMS_SCHEDULER.CREATE_JOB ( * ERROR at line 2: ORA-06550: line 2, column 1: PLS-00201: identifier 'DBMS_SCHEDULER.CREATE_JOB' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored - Muthu Kumar. |
| ||||
| On 28 Dec 2005 21:37:16 -0800, "Muthu Kumar G" <g.muthukumar@gmail.com> wrote: >what could be the error... > >SQL> begin > 2 DBMS_SCHEDULER.CREATE_JOB ( > 3 job_name =>'create_dir_test', > 4 job_type =>'executable', > 5 job_action => 'c:\winnt\system32\cmd.exe /c mkdir c:\test\test1', > 6 enabled =>true,auto_drop => true > 7 ); > 8 commit; > 9 end; > 10 / >DBMS_SCHEDULER.CREATE_JOB ( >* >ERROR at line 2: >ORA-06550: line 2, column 1: >PLS-00201: identifier 'DBMS_SCHEDULER.CREATE_JOB' must be declared >ORA-06550: line 2, column 1: >PL/SQL: Statement ignored > >- Muthu Kumar. Insufficient privileges (likely) or lack of synonym (unlikely), which is unvariably the cause of PLS-201, apart from typing errors. -- Sybrand Bakker, Senior Oracle DBA |