From oracle-l-bounce@freelists.org Tue Feb 24 13:00:58 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OJ0wt23140 for ; Tue, 24 Feb 2004 13:00:58 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1OJ0so23130 for ; Tue, 24 Feb 2004 13:00:54 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66B4E3953FD; Tue, 24 Feb 2004 14:01:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 14:00:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60A79395D7E for ; Tue, 24 Feb 2004 14:00:08 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id A4F46142E41; Tue, 24 Feb 2004 11:02:44 -0800 (PST) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAAc4psO_; Tue Feb 24 11:02:33 2004 To: oracle-l@freelists.org Subject: Re: 7.3 anyone? MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Jared.Still@radisys.com Date: Tue, 24 Feb 2004 11:02:32 -0800 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 5.0.12 |February 13, 2003) at 02/24/2004 10:59:48 AM, Serialize complete at 02/24/2004 10:59:48 AM Content-Type: multipart/alternative; boundary="=_alternative 0068860088256E44_=" X-archive-position: 1773 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=_alternative 0068860088256E44_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Exacly which version of Oracle 7.x w= ould 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.o= rg

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

       
        To: &nbs= p;      <oracle-l@freelists.org>
        cc: &nbs= p;      
        Subject:=        Re: 7.3 anyone?



SVRMGR> connect internal
Connected.
SVRMGR> desc dbms=5Fsystem
package dbms=5Fsystem is
 ------------
 --  OVERVIEW
 --
 --  This package provides some system level utilities.
 
  --  SECURITY
 --
 --  This package is only accessible to user SYS by default. &nb= sp;You can control
 --  access to these routines by only granting execute to privil= eged users.
 
  ----------------------------
 --  PROCEDURES AND FUNCTIONS
 --
 procedure set=5Fev(si binary=5Finteger, se binary=5Finteger,
                  ev binary= =5Finteger, le binary=5Finteger, nm varchar2);
 --  This is an internally used routine that should never be cal= led by users.
 
  procedure read=5Fev(iev binary=5Fi= nteger, oev out binary=5Finteger);
 --  This is an internally used routine that should never be cal= led by users.
 --
 --
 procedure dist=5Ftxn=5Fsync(inst=5Fnum number);
 --  This should be normally be only called by the XA library.
 
  procedure set=5Fsql=5Ftrace=5Fin= =5Fsession(sid number, serial# number,
                    &nbs= p;               sql=5Ftrace boolean);  --  Enable sql=5Ftrace in the session identified by (sid, seria= l#).  These
 
  --  value are gotten from v$s= ession.
 --  Input arguments:
 --   sid
 --      session id
 --   serial#
 --      session serial number
 --  sql=5Ftrace
 --      if true then enable tracing, if false disable= tracing.
 --
 
  procedure ksdwrt(dest in binary=5F= 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 bot= h)
 --        for specifying both, the value of dest= should be
 --        trace=5Ffile+alert=5Ffile
 -- 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=5Fi= nteger);
 -- 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 ru= nning the following query?
 
connect sys
desc dbms=5Fsystem
exit;
 
Again, thanks in advance.
 

Cary Millsap
Hotsos Enterprises, Ltd.<= u>
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...
 

--=_alternative 0068860088256E44_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------