OraFAQ Forum: Server Administration » DBMS

Home » RDBMS Server » Server Administration » DBMS_JOB.SUBMIT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_JOB.SUBMIT [message #51735]

Tue, 11 June 2002 04:01

Pushpa Godhania
Messages: 2
Registered: June 2002

Junior Member

Hello,

I'm getting an error when I try to submit a job. Anyone have any ideas? We're using Oracle release 7.3.2. Details shown below:

SQL> select user from dual;

USER
------------------------------
REPADMIN

SQL> create table potest
2 (a_col varchar(20));

Table created.

SQL> commit;

Commit complete.

SQL>
create or replace procedure test_proc
SQL> 2 is
3 begin
4 insert into potest
5 values (to_char(sysdate, 'DD-MON-YY HH24:MI'));
6 commit;
7 end;
8 /

Procedure created.

SQL> execute test_proc;

PL/SQL procedure successfully completed.

SQL> select * from potest;

A_COL
--------------------
11-JUN-02 11:20

SQL>
SQL>
SQL> variable jobno number;
SQL> begin
2 dbms_job.submit(:jobno, 'repadmin.test_proc', SYSDATE);
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 103:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 71
ORA-06512: at "SYS.DBMS_JOB", line 121
ORA-06512: at line 2

SQL> l
1 select object_name, status, object_type
2 from all_objects
3* where object_name = 'DBMS_JOB'
SQL> /

OBJECT_NAME STATUS OBJECT_TYPE
------------------------------ ------- ------------
DBMS_JOB VALID PACKAGE
DBMS_JOB VALID PACKAGE BODY
DBMS_JOB VALID SYNONYM

Report message to a moderator

Re: DBMS_JOB.SUBMIT [message #51737 is a reply to message #51735]

Tue, 11 June 2002 07:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to add a semicolon ';' with name of the proc you are submitting.
something like this.

SQL> ED
Wrote file afiedt.buf

  1  begin
  2  dbms_job.submit(:jobno, 'test_proc;', SYSDATE);
  3* end;
SQL> /

PL/SQL procedure successfully completed.

SQL>

Report message to a moderator

Re: DBMS_JOB.SUBMIT [message #51757 is a reply to message #51735]

Wed, 12 June 2002 06:02

kiran srirama
Messages: 14
Registered: March 2002

Junior Member

replace this line

dbms_job.submit(:jobno, 'repadmin.test_proc', SYSDATE);

with

dbms_job.submit(:jobno, 'repadmin.test_proc;', SYSDATE);

thats it!

Kiran

Report message to a moderator

Re: DBMS_JOB.SUBMIT [message #185512 is a reply to message #51735]

Wed, 02 August 2006 01:49

fisol
Messages: 1
Registered: August 2006

Junior Member

here's my job i would like to submit :

begin
sys.dbms_job.submit(job => :jobno,
what => 'otl_batch;',
next_date => to_date('04-08-2006', 'dd-mm-yyyy'),
interval => 'sysdate + 7');
commit;
end;

ORA-01008: not all variables bound

what is the error is about? can you help? tq..

fisol

Report message to a moderator

Previous Topic:	DSGA
Next Topic:	accessing DB through excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:24:28 CDT 2024