what's wrong with this...DBMS

From: Tirumala, Surendra <Surendra.Tirumala_at_am.sony.com>
Date: Mon, 11 Jun 2001 13:29:45 -0700
Message-ID: <F001.00324865.20010611125520@fatcity.com>

Hi List,

As the part of developing hot backup strategy, I am testing the following piece of code
to take care of arch files to be made avaialable along with backup set.

SQL> create or replace procedure log_switch as   2 cursor1 integer;
  3 begin
  4 cur1 := dbms_sql.open_cursor;
  5 dbms_sql.parse(cur1,'ALTER SYSTEM SWITCH LOGFILE', dbms_sql.v7);   6 dbms_sql.close_cursor(cur1);
  7 end;
  8 /

Procedure created.

SQL> execute log_switch;

PL/SQL procedure successfully completed.

But, I have observed several times that the above code is not forcing a log switch.
FYI, I want to track the sequence# of logfiles before and after the hot backup, so that
I can backup the files in that range.

Am I properly using the DBMS_SQL?
Any help is highly appreciated

TIA,
Suren
Oracle DBA
Sony
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tirumala, Surendra
INET: Surendra.Tirumala_at_am.sony.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). Received on Mon Jun 11 2001 - 15:29:45 CDT

what's wrong with this...DBMS_SQL