Re: submit ERROR

thanks a lot ...guys !!!

Malik Michael <mmalyk_at_cryptologic.com> on 27/10/2000 10:46:31 AM

Please respond to ORACLE-L_at_fatcity.com

                                                                                
                                                                                
                                                                                


                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Marcos Vera/M&S Consultores/51)               
                                                              
                                                              
                                                              
 Subject: 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Malik Michael
  INET: mmalyk_at_cryptologic.com

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