Doesn't woprk for me.
14:17:21 - jkstill@ SQL> desc sys.dbms_system
SP2-0581: Object sys.dbms_system is a package; use 'DESCRIBE <package>.<procedure>'
14:17:27 - jkstill@ SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Workgroup Server Release 7.3.4.5.0 - Production
PL/SQL Release 2.3.4.5.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.1 - Production
5 rows selected.
14:17:44 - jkstill@ SQL>
|
| "OrclBabu" <orclbabu@hotmail.com>
Sent by: oracle-l-bounce@freelists.org
02/24/2004 01:27 PM
Please respond to oracle-l
|
To: <oracle-l@freelists.org>
cc:
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
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 - 16:15:54 CST
