RE: submit ERROR

From: Gabriel Galanternik <ggalanterni_at_tesis-oys.com.ar>
Date: Fri, 27 Oct 2000 10:56:09 -0300
Message-Id: <10662.120439@fatcity.com>

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 ----- From: Marcos.Vera_at_msconsultores.com.pe Subject: submit ERROR 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 ?? Received on Fri Oct 27 2000 - 08:56:09 CDT