From oracle-l-bounce@freelists.org Tue Feb 24 16:15:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OMFsK02720 for ; Tue, 24 Feb 2004 16:15:54 -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 i1OMFno02706 for ; Tue, 24 Feb 2004 16:15:49 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E59953955DC; Tue, 24 Feb 2004 17:17:05 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 17:15:59 -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 EBA0039545C for ; Tue, 24 Feb 2004 17:15:56 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 51F0B142E07; Tue, 24 Feb 2004 14:18:35 -0800 (PST) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAAdjigK_; Tue Feb 24 14:18:22 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 14:18:16 -0800 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 5.0.12 |February 13, 2003) at 02/24/2004 02:15:35 PM, Serialize complete at 02/24/2004 02:15:35 PM Content-Type: multipart/alternative; boundary="=_alternative 007A718588256E44_=" X-archive-position: 1820 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 007A718588256E44_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Doesn't woprk for me.


14:17:21  - jkstill@ SQL> de= sc sys.dbms=5Fsystem
SP2-0581: Object sys.dbms=5Fsystem i= s a package; use 'DESCRIBE <package>.<procedure>'
14:17:27  - jkstill@ SQL> se= lect * from v$version;

BANNER
------------------------------------= ----------------------------
Oracle7 Workgroup Server Release 7.3= .4.5.0 - Production
PL/SQL Release 2.3.4.5.0 - Productio= n
CORE Version 3.5.4.0.0 - Production<= /font>
TNS for 32-bit Windows: Version 2.3.= 4.0.0 - Production
NLSRTL Version 3.2.4.0.1 - Productio= n

5 rows selected.

14:17:44  - jkstill@ SQL>





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

 02/24/2004 01:27 PM
 Please respond to oracle-l

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



Its from a 7.3.4.. We may have the turbo = patch on ;-)
 
SVRMGR> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Server Release 7.3.4.5.0 with the 64-bit option - Produc
PL/SQL Release 2.3.4.5.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 - Production
5 rows selected.
 
 
Babu
----- Original Message -----
From: Jared.Still@radisys.com
To: oracle-l@freelists.org
Sent: Tuesday, February = 24, 2004 2:02 PM
Subject: Re: 7.3 anyone?=


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<= /font>

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

        <= /font>
       To:        <oracle-l@freelists.org>
       cc:         <= br>        Subject:        Re: 7.3 any= one?




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.  You= can control
--  access to these routines by only granting execute to privileged u= sers.
 
 ----------------------------
--  PROCEDURES AND FUNCTIONS
--
procedure set=5Fev(si binary=5Finteger, se binary=5Finteger,
                 ev binary=5F= integer, le binary=5Finteger, nm varchar2);
--  This is an internally used routine that should never be called by= users.
 
 procedure read=5Fev(iev binary=5Finteger, oev out binary=5Finteger);=
--  This is an internally used routine that should never be called by= users.
--
--
procedure dist=5Ftxn=5Fsync(inst=5Fnum number);
--  This should be normally be only called by the XA library.<= font size=3D3 face=3D"Times New Roman">
 
 procedure set=5Fsql=5Ftrace=5Fin=5Fsession(sid number, serial# numbe= r,
                    &nbs= p;              sql=5Ftrace boolean);
--  Enable sql=5Ftrace in the session identified by (sid, serial#). &= nbsp;These
 
 --  value are gotten from v$session.
--  Input arguments:
--   sid
--      session id
--   serial#
--      session serial number
--  sql=5Ftrace
--      if true then enable tracing, if false disable traci= ng.
--
 
 procedure ksdwrt(dest in binary=5Finteger, 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 shoul= d be
--        trace=5Ffile+alert=5Ffile
-- tst - Trace string to print.
 
 procedure ksdfls;
 -- flush the output written to trac= e file.
 
 procedure ksdddt;
-- Dump date and time information to trace file
 
 procedure ksdind(lvl in binary=5Finteger);
-- 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?<= font size=3D3 face=3D"Times New Roman">
 
connect sys
desc dbms=5Fsystem
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... =
 

--=_alternative 007A718588256E44_=-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------