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).

Reply via email to