DBMS_JOB problem

From: Magaliff, Bill <Bill.Magaliff_at_lendware.com>
Date: Fri, 13 Dec 2002 08:59:21 -0800
Message-ID: <F001.005194B7.20021213085921@fatcity.com>

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). Received on Fri Dec 13 2002 - 10:59:21 CST