Re: Code of packages

Do a desc on the table user_source.

SQL> desc user_source

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 NAME                                              VARCHAR2(30)
 TYPE                                               VARCHAR2(12)
 LINE                                                NUMBER
 TEXT                                               VARCHAR2(4000)

The 'TEXT' column contains a line of code. Select all the lines for your package name and order by 'LINE', which is the line number of the 'TEXT' column.

Good luck.

On Thu, 20 Sep 2001 18:55:18 +0200, Guenter Huerkamp <guenter-huerkamp_at_t-online.de> wrote:

>Zemotard wrote:
>
>> I don't understant your answer.
>> I would like to recover the source code of my package to strore them in a
>> text file but i don't know the command to see packages and packages bodies
>> with SQLPLUS.
>> To create my packages i use OEM.
>>
>> Thanks
>>
>> "daniele stefanucci" <d.stefanucci_at_edisontel.it> a écrit dans le message
>> news: sZiq7.3067$Wg4.13441319_at_news.edisontel.com...
>>
>>>You can find the code in this table : user_source or dba_source
>>>"Zemotard" <nicolas.ponchel_at_orange.fr> ha scritto nel messaggio
>>>news:9ocdu2$bo6$1_at_wanadoo.fr...
>>>
>>>>Hello,
>>>>I want to recover the source code of my packages and packages body to
>>>>
>>>create
>>>
>>>>a script SQL.
>>>>What 's the syntax please ?
>>>>
>>>>Thank you
>>>>
>>>>
>>>>
>>>
>>
>>
>
>Then try OEM and save the package to a text file.
>Günter
>
>
>---------------------------------------------------------------
>
Received on Thu Sep 20 2001 - 14:25:29 CDT