Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 7.3 anyone?

Re: 7.3 anyone?

From: <Jared.Still_at_radisys.com>
Date: Tue, 24 Feb 2004 11:02:32 -0800
Message-ID: <OFBBC5CCB9.ABB9E88F-ON88256E44.0068873F-88256E44.00688603@radisys.com>



Exacly which version of Oracle 7.x would this be from?

To the best of my knowledge, doing a describe on a package
never worked this way in 7.x.

Jared



"OrclBabu" <orclbabu@hotmail.com>
Sent by: oracle-l-bounce@freelists.org

 02/24/2004 08:33 AM
 Please respond to oracle-l

       
        To:        <oracle-l@freelists.org>
        cc:        
        Subject:        Re: 7.3 anyone?



SVRMGR> connect internal
Connected.
SVRMGR> desc dbms_system
package dbms_system is
 ------------
 --  OVERVIEW
 --
 --  This package provides some system level utilities.

 
  --  SECURITY
 --
 --  This package is only accessible to user SYS by default.  You can control
 --  access to these routines by only granting execute to privileged users.

 
  ----------------------------
 --  PROCEDURES AND FUNCTIONS
 --
 procedure set_ev(si binary_integer, se binary_integer,
                  ev binary_integer, le binary_integer, nm varchar2);
 --  This is an internally used routine that should never be called by users.

 
  procedure read_ev(iev binary_integer, oev out binary_integer);
 --  This is an internally used routine that should never be called by users.
 --
 --
 procedure dist_txn_sync(inst_num number);
 --  This should be normally be only called by the XA library.

 
  procedure set_sql_trace_in_session(sid number, serial# number,
                                    sql_trace boolean);
 --  Enable sql_trace in the session identified by (sid, serial#).  These

 
  --  value are gotten from v$session.
 --  Input arguments:
 --   sid
 --      session id
 --   serial#
 --      session serial number
 --  sql_trace
 --      if true then enable tracing, if false disable tracing.
 --

 
  procedure ksdwrt(dest in binary_integer, tst in varchar2);
 -- Print the given string out to the trace file.
 -- Input arguments
 -- dest - destination of the output (Alert file or Trace file or both)
 --        for specifying both, the value of dest should be
 --        trace_file+alert_file
 -- tst - Trace string to print.

 
  procedure ksdfls;
 -- flush the output written to trace file.

 
  procedure ksdddt;
 -- Dump date and time information to trace file

 
  procedure ksdind(lvl in binary_integer);
 -- Set the indentation level for the further output to trace file.
 -- Level - the level of indentation.
end;

----- Original Message -----
From: Cary Millsap
To: oracle-l@freelists.org
Sent: Tuesday, February 24, 2004 2:37 AM
Subject: 7.3 anyone?

Would someone with a 7.3 database mind running the following query?
 
connect sys
desc dbms_system
exit;
 
Again, thanks in advance.
 

Cary Millsap
Hotsos Enterprises, Ltd.

http://www.hotsos.com
Nullius in verba


Upcoming events:
-
Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
-
Hotsos Symposium 2004: March 7–10 Dallas
- Visit
www.hotsos.com for schedule details...
 



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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 13:00:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US