Re: how to describe a packaged procedure

From: <argosy22_at_my-deja.com>
Date: Wed, 05 Jan 2000 20:43:45 GMT
Message-ID: <850adt$f2v$1@nnrp1.deja.com>

Try this in a sqlplus script:

accept ls_package_name prompt "Enter the package to list code for: " ; Select text
from all_source
where name = rtrim(ltrim(upper( '&ls_package_name' ))) and type = 'PACKAGE BODY'
order by owner, name, line;

Hope it's what you need.

Argosy

In article <85066p$bho$1_at_nnrp1.deja.com>, Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> hi
>
> how can i describe a procedure in a package from the SQL command
prompt?
> Thanks in advance
>
> --
> Nandakumar
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 05 2000 - 14:43:45 CST