RE: sqlplus question

I was also trying to put some script on Oracle scheduler and successful too. But on Oracle 8
I failed. It was successful on Oracle 8i (8 doesn't support execute immediate). Would appreciate,
if someone can give equivalent code for Oracle 8.

        Here is the code for Oracle 8i,

create or replace PROCEDURE SWITCH IS
  2 BEGIN
  3 execute immediate 'alter system switch logfile ';   4 commit ;
  5 END;
6 /

Thanks in Advance,
Rajesh
NOTE: It would be executed with any user having sysdba privilege.

-----Original Message-----
Faroult
Sent: Tuesday, January 29, 2002 11:40 AM To: Multiple recipients of list ORACLE-L

And if you are running an unavowable OS, you can probably turn your SQL*Plus script into a jPL/SQL procedure and schedule it using dbms_job.

"Weaver, Walt" wrote:
>
> Cron? At?
>
> -----Original Message-----
> Sent: Monday, January 28, 2002 3:21 PM
> To: Multiple recipients of list ORACLE-L
>
> Hello,
> I need to run some script using Oracle Sqlplus. The script is only
suppose
> to run certain days of week.
> Does anyone have a suggestion how to do that.
>
> Thank you.
> --

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).