DBMS_JOB Package

From: Krenn Philipp <krennp_at_vossen.com>
Date: Wed, 24 Nov 1999 23:28:41 +0100
Message-ID: <383C6699.24E7038B@vossen.com>

Hi everybody!

Can anybody tell me what i've done wrong?

In my initORCL.ora are the two parameters:

JOB_QUEUE_PROCESSES = 1
JOB_QUEUE_INTERVAL = 60 When I try to execute the following statment I get an error-message like this:

SQL> variable jobnum number;
SQL> begin
  2 dbms_job.submit(:jobnum,'insert into protokoll values(sysdate,'dbms-test');',
  3 sysdate,sysdate+1);
  4 commit;
  5 end;
  6 /
dbms_job.submit(:jobnum,'insert into protokoll values(sysdate,'dbms-test');',

                                                               *

ERROR in Line 2:

ORA-06550: line 2, column 64:
PLS-00103: Encountered the symbol "DBMS" when expecting one of the
following:

. ( ) , * @ % & | = - + < / > in mod not range rem => ..
an exponent (**) <> or != or ~= >= <= <> and or like between is null is not || is dangling

regards
phil Received on Wed Nov 24 1999 - 16:28:41 CST