Re: Need help on dbms_output....

Satish Narasimha wrote:
>
> Hello,
>
> Can anybody tell me where i can get the help on all the dbms_output..
> packages are available...?
>
> and brief explanation about what each package is used for.....
>
> Thanks in advance...
> satish
>
> E-Mail : satish.muc_at_sni.de
> : somasatish_at_hotmail.com

Normally it should be somewhere in one of the manuals (don't know exactly  which one), but if you can't find it, you can get some information in the package itself by executing (e.g. in SQL*Plus):

select text from all_source
where name = 'DBMS_OUTPUT'
and owner = 'SYS'
and type = 'PACKAGE'
order by line;

To get a list of packages (owned by sys):

select distinct name
from all_source
where owner = 'SYS'
and type = 'PACKAGE';

Of course it's not sure that all these packages are supported.

Marc Received on Mon Sep 01 1997 - 00:00:00 CDT