FW: DBMS_JOB problem

OK OK so I missed the semicolon after the 'statspack.snap' command . . . sorry.

problem fixed - back to normal state.

-bill

> -----Original Message-----
> From: Magaliff, Bill
> Sent: Friday, December 13, 2002 11:55 AM
> To: Oracle-L (E-mail)
> Subject: DBMS_JOB problem
>
> 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: Bill.Magaliff_at_lendware.com

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