Re: DBMS_JOB question

On Tue, 26 Nov 2002 14:16:57 +0100, "Dirk Tschentscher" <dirk.tschentscherREM_at_THISvolkswagen.de> wrote:

>Hi Jan,
>I tried
>create or replace procedure job_start as
> jobno number;
>BEGIN
> DBMS_JOB.SUBMIT(jobno,
> 'sys.jg_load_objects', --an SP that has already been
>testedsuccessfully
> SYSDATE,
> 'SYSDATE + 1/48' --every half an hour
> );
>END;
>
>it works fine...
>but I think you need a ";" after "sys.jg_load_objects"
>
>Rgds
> Dirk
>
>"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> schrieb im Newsbeitrag
>news:arvrqn$m9q0u$1_at_ID-152732.news.dfncis.de...
>> Hello, folks,
>>
>> I maybe a complete blind fish, but why the heck wont the folowing compile
>?
>>
>> DECLARE
>> jobno number;
>> BEGIN
>> DBMS_JOB.SUBMIT(jobno,
>> 'sys.jg_load_objects', --an SP that has already been tested
>> successfully
>> SYSDATE,
>> 'SYSDATE + 1/48' --every half an hour
>> );
>> END;
>> /
>>
>> AFAIK it complies with the examples in the online doc CD. I compared Tom
>> Kytes book as well ... I have no clue.
>>
>> Any comments are appreciated. ThanX !
>> Oracle EE 8.1.7, SQL*Plus
>>
>> Jan
>>
>>
>

Also it is definitely *A VERY BAD IDEA* to create your *OWN* procedures in the *SYS* schema.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Nov 26 2002 - 11:22:38 CST