RE: 7.3 anyone?
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 01:05:46 -0800
yup. 01:00
Have to get up soon. ;)
Got a bit obsessed with getting the current version
of Vim to work correctly with syntax highlighting and
ctags.
Reading the manual helped. :)
Both work very well with SQL and PL/SQL
Jared
On Tue, 2004-02-24 at 00:13, Khedr, Waleed wrote:
> Good night
>
> Waleed
>
> -----Original Message-----
> From: Jared Still [mailto:jkstill@xxxxxxxxxx]
> Sent: Tuesday, February 24, 2004 3:16 AM
> To: Oracle-L Freelists
> Cc: Cary Millsap
> Subject: Re: 7.3 anyone?
>
>
> Isn't it bedtime in Dallas?
>
> desc dbms_system does not work in 7.3
>
>
> 00:08:44 - sys@ SQL> desc dbms_system
> SP2-0581: Object dbms_system is a package; use 'DESCRIBE
> <package>.<procedure>'
> 00:08:46 - sys@ SQL>
>
>
> However, this does:
>
> 1 select line,text from dba_source
> 2* where name = 'DBMS_SYSTEM' and type = 'PACKAGE'
> 00:08:13 - sys@ SQL> /
>
> LINE TEXT
> ---------- --------------------------------------------------
> 1 package dbms_system is
> 2 ------------
> 3 -- OVERVIEW
> 4 --
> 5 -- This package provides some system level util
> ities.
>
> 6
> 7 -- SECURITY
> 8 --
> 9 -- This package is only accessible to user SYS
> by default. You can control
>
> 10 -- access to these routines by only granting ex
> ecute to privileged users.
>
> 11
> 12 ----------------------------
> 13 -- PROCEDURES AND FUNCTIONS
> 14 --
> 15 procedure set_ev(si binary_integer, se binary_in
> teger,
>
> 16 ev binary_integer, le binary_integer,
> nm varchar2);
>
> 17 -- This is an internally used routine that shou
> ld never be called by users.
>
> 18
> 19 procedure read_ev(iev binary_integer, oev out bi
> nary_integer);
>
> 20 -- This is an internally used routine that shou
> ld never be called by users.
>
> 21 --
>
> LINE TEXT
> ---------- --------------------------------------------------
> 22 --
> 23 procedure dist_txn_sync(inst_num number);
> 24 -- This should be normally be only called by th
> e XA library.
>
> 25
> 26 procedure set_sql_trace_in_session(sid number, s
> erial# number,
>
> 27 sql_trace boolean);
> 28 -- Enable sql_trace in the session identified b
> y (sid, serial#). These
>
> 29 -- value are gotten from v$session.
> 30 -- Input arguments:
> 31 -- sid
> 32 -- session id
> 33 -- serial#
> 34 -- session serial number
> 35 -- sql_trace
> 36 -- if true then enable tracing, if false di
> sable tracing.
>
> 37 --
> 38
> 39 procedure ksdwrt(dest in binary_integer, tst in
> varchar2);
>
> 40 -- Print the given string out to the trace file.
>
>
> 41 -- Input arguments
> 42 -- dest - destination of the output (Alert file
> or Trace file or both)
>
> 43 -- for specifying both, the value of dest
> should be
>
> LINE TEXT
> ---------- --------------------------------------------------
>
> 44 -- trace_file+alert_file
> 45 -- tst - Trace string to print.
> 46
> 47 procedure ksdfls;
> 48 -- flush the output written to trace file.
> 49
> 50 procedure ksdddt;
> 51 -- Dump date and time information to trace file
> 52
> 53 procedure ksdind(lvl in binary_integer);
> 54 -- Set the indentation level for the further out
> put to trace file.
>
> 55 -- Level - the level of indentation.
> 56 end;
>
> 56 rows selected.
>
>
> Jared
>
> On Mon, 2004-02-23 at 23:37, Cary Millsap wrote:
> > 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
