Re: PL/SQL Execute permissions

"Thomas J. Kyte" wrote:
>
> In article <3940FDB2.CF5_at_yahoo.com>,
> connor_mcdonald_at_yahoo.com wrote:
> > Thomas J. Kyte wrote:
> >
> > Thomas - is there any doco (offical or otherwise) about DBMS_SYSTEM.
> > Naturally you can see the public parts of the package (SET_EV etc etc)
> > but actually knowing what each proc does has always been somewhat
> > guesswork for me...
> >
>
> with the exception of set_sql_trace_in_session, the contents of
> dbms_system are undocumented and much like the _init.ora parameters,
> are to be used only at the direction of support.

Actually, there is a good description in "Oracle Built-in Packages" an O'Reilly book written by Feuerstein/Dye/Beresniewicz.

The method I mostly use is ksdwrt() so that I can write messages to the alert log and trace files. I don't see where this is dangerous - advanced perhaps, but not dangerous. If Oracle wants to keep DBMS_SYSTEM mostly undocumented why not move ksdwrt to another package and then document it? Received on Mon Jun 12 2000 - 00:00:00 CDT