Hi there,
SELECT source
FROM source$ a, obj$ b
WHERE a.obj# = b.obj# AND
b.name = 'Procedure Name'
ORDER BY line;
---- palani
<elufker_at_llama.swcp.com> wrote in message
news:86pvqk$63r$1_at_sloth.swcp.com...
> Hi All;
>
> How would I see the contents of a procedure?? I tried to do a
>
> select name, text from dba_source where owner = 'CTXSYS' and name like
> 'CTX_SV%';
>
> I see the procedure in the package, but I wanted to see the
> contents of the procedure.
>
> Thanks in advance for any info
> Eddie Lufker
>
>
Received on Fri Jan 28 2000 - 02:01:25 CST