Re: DBMS_JOB Package

Hello,

I think you need to put double quotes round ''dbms-test''. I tried to get it to work after that and then got an error to do with the sysdate insert. The error I got was ORA-23319: parameter value "04.12.99" is not appropriate. I am almost sure the double quotes are needed so if you can solve the next error you are there.

Cheers
Eric F

Krenn Philipp wrote in message <383C6699.24E7038B_at_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 Fri Dec 03 1999 - 04:45:53 CST