Re: submit ERROR

You can rewrite your DBMS_JOB.SUBMIT procedure like this :

  DBMS_JOB.SUBMIT(NSUBMIT,'begin SPPRUEBA; end;',SYSDATE);

If SPPRUEBA is store procedure you must to execute it in begin .... end bloc and
you have to have 'execute' privilege for it.

Michael Malyk
 Cryptologic Inc., Database Programmer

Marcos.Vera_at_msconsultores.com.pe wrote:

> HI GUYS ...
> WHEN I TRY TO SUBMIT A JOB ..FOR EXAMPLE
>
> declare NSUBMIT BINARY_INTEGER;
> BEGIN
> DBMS_JOB.SUBMIT(NSUBMIT,'SPPRUEBA',SYSDATE);
> END;
>
> I GET THIS ERROR
>
> *****************************************************
> The following error has occurred:
> ORA-06550: line 1, column 102:
> 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 72
> ORA-06512: at "SYS.DBMS_JOB", line 140
> ORA-06512: at line 3
> *****************************************************
>
> WHY ??? SUGGESTIONS ?? BAD COMPILE ??
>
> THANKS.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Marcos.Vera_at_msconsultores.com.pe
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 27 2000 - 09:44:03 CDT