Re: DBMS_SCHEDULER.CREATE_JOB

On 28 Dec 2005 21:37:16 -0800, "Muthu Kumar G" <g.muthukumar_at_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