Home » RDBMS Server » Server Administration » DBMS_JOB.SUBMIT
DBMS_JOB.SUBMIT [message #51735] Tue, 11 June 2002 04:01 Go to next message
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
Re: DBMS_JOB.SUBMIT [message #51737 is a reply to message #51735] Tue, 11 June 2002 07:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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> 
Re: DBMS_JOB.SUBMIT [message #51757 is a reply to message #51735] Wed, 12 June 2002 06:02 Go to previous messageGo to next message
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
Re: DBMS_JOB.SUBMIT [message #185512 is a reply to message #51735] Wed, 02 August 2006 01:49 Go to previous message
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
Previous Topic: DSGA
Next Topic: accessing DB through excel
Goto Forum:
  


Current Time: Mon Dec 05 20:58:57 CST 2016

Total time taken to generate the page: 0.14520 seconds