Re: How to access procedure
Date: Tue, 20 Oct 1998 07:42:03 GMT
Message-ID: <70hesb$ott$1_at_nnrp1.dejanews.com>
In article <362BED32.7FA9_at_cis0.levels.unisa.edu.au>,
Nongporn Lilian <9711256p_at_cis0.levels.unisa.edu.au> wrote:
> Hello
>
> I wrote PL/SQL block in SQL/PLUS. How can I access private and public
> procedure in CREATE OR REPLACE PACKAGE block.
>
> Nongporn
>
Presumably what your after is the underlying dictionary view that you can
access your source code in.
Have a look at ALL_SOURCE.
To query back your source within SQL*Plus, use the following settings:
SET LONG 25000
SET PAGES 2000
Then to query your source code use the following SQL :
SELECT TEXT
FROM ALL_SOURCE
WHERE NAME = 'name_of_your_procedure/package_in_upper_case';
Hope this helps
Regards
Gareth
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 09:42:03 CEST