Re: DBMS_JOB Package

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Thu, 25 Nov 1999 13:28:42 +0100
Message-ID: <383D2B79.55A0152E@unilog.fr>

Krenn Philipp wrote :

> ...
>
> SQL> variable jobnum number;
> SQL> begin
> 2 dbms_job.submit(:jobnum,'insert into protokoll

                                                 ^ first quote

>
> values(sysdate,'dbms-test');',

                          ^ last quote and end of the statement !!

>
> 3 sysdate,sysdate+1);

I don't know anything about DBMS_JOB, but, with SQL*Plus, you must double a quote in
a string. So, try this :

values(sysdate,' 'dbms-test' ');', /* I put a space between the both quotes just for readability !! */

Best regards.

Pierre Received on Thu Nov 25 1999 - 06:28:42 CST