DBMS_JOB package
From: Gerhard Holzer <holzer_g_at_aut.alcatel.at>
Date: 1996/07/15
Message-ID: <4sd2mg$ob3_at_atusks02.aut.alcatel.at>#1/1
SQL> variable X number;
Date: 1996/07/15
Message-ID: <4sd2mg$ob3_at_atusks02.aut.alcatel.at>#1/1
Anybody out there used the dbms_job package ?? Experiences ??
What I'm doing wrong trying the following:
SQL> variable X number;
SQL> execute dbms_job.submit( :X, 'my_proc( par1, par2 )' );
begin dbms_job.submit( :X, 'my_proc( par1, par2 ) ' ); end;
*
ERROR at line 1:
ORA-06550: line 1, column 88:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( % ;
; was inserted before "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 66 ORA-06512: at "SYS.DBMS_JOB", line 117 ORA-06512: at line 1
_____________________________________________________________________________
Known Bug/Problems/... ???
I would prefer to get answers per Email (faster!)
Many Thanks in advance !!
__ __
_________| |_____\/______ //-// _____ +-----------------------------------+ / Gerhard Holzer (Gucky) | \ | Email: holzer_g_at_aut.alcatel.at / +----------------------------------------+ | Tel : +(431) 27722/3573 + | Alcatel Austria AG | | Fax : +(431) 27722/171/ o \ \ | Scheydgasse 41 | ++---------------------/ -|- \----+ | A-1211 Vienna - Austria - Europe | || / \ +----------------------------------------+-++ - - Gerhard.Holzer_at_aut.alcatel.atReceived on Mon Jul 15 1996 - 00:00:00 CEST