Try putting a ';' after snap that may fix it.
SQL> variable x number;
SQL> begin
2 dbms_job.submit(:x,'statspack.snap;',sysdate,'sysdate + 1/24');
3 end;
4 /
I'm trying to use DBMS_JOB to schedule hourly statspack snaps. Per note on
Metalink, I've try to run the following:
SQL> variable x number;
SQL> begin
2 dbms_job.submit(:x,'statspack.snap',sysdate,'sysdate + 1/24');
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06550: line 1, column 108:
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 79
ORA-06512: at "SYS.DBMS_JOB", line 131
ORA-06512: at line 2
Any ideas on this error? No helpful info on Metalink.
Checked the status of the package, too:
1* select object_type, status from all_objects where object_name =
'DBMS_JOB'
SQL> /
OBJECT_TYPE STATUS
------------------ -------
PACKAGE VALID
SYNONYM VALID
Thanks
bill
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Magaliff, Bill
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
