Re: submit ERROR

Oracle's job executes PL/SQL block, so what you need is:

declare NSUBMIT BINARY_INTEGER;
BEGIN
DBMS_JOB.SUBMIT(NSUBMIT,'begin SPPRUEBA; end;',SYSDATE); END; Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- From: "Gabriel Galanternik" <ggalanterni_at_tesis-oys.com.ar> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, October 27, 2000 11:01 AM Subject: RE: submit ERROR

> I think you need a ; after sprueba.
>
> declare NSUBMIT BINARY_INTEGER;
> BEGIN
> DBMS_JOB.SUBMIT(NSUBMIT,'SPPRUEBA;',SYSDATE);
> END;
>
> don't you?
>
> Gabriel
> -----------------------------
> Gabriel Galanternik
> Tesis OyS
> -Que tengas un muy buen dia!-
> -----------------------------
>
> ----- Original Message -----
> 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: Gabriel Galanternik
> INET: ggalanterni_at_tesis-oys.com.ar
>
> 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 - 10:09:19 CDT