RE: 7.3 anyone?

From: Jared Still <jkstill_at_cybcon.com>
Date: Tue, 24 Feb 2004 01:05:46 -0800
Message-Id: <1077613546.11042.193.camel@poirot>

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_at_cybcon.com]
> 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_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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------

---

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 - 02:57:06 CST