Re: packages

Bonjour Nicolas,

select text from user_code where name='ton package' order by line;

or from all_code or dba_code depending on who's the owner and granted rights.

..._code are system views showing source code for stored functions, procedures and packages.

Feel free to ask if you need more info.
If you are more comfee with French, it's OK with me.

   Pas de problème en ce qui me concerne :-)    A+

HTH,

--
Today, Tomorrow, Together
The DOC
(The Dutch Oracle Company)

Xavier.


"Zemotard" <nicolas.ponchel_at_orange.fr> wrote in message news:9od350$1v6$1_at_wanadoo.fr...


> 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

>

>

>

>