Unix Technical Forum

DBMS_SCHEDULER.CREATE_JOB

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 => ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 08:26 AM
Muthu Kumar G
 
Posts: n/a
Default DBMS_SCHEDULER.CREATE_JOB

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 08:26 AM
Sybrand Bakker
 
Posts: n/a
Default Re: DBMS_SCHEDULER.CREATE_JOB

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com