Re: packages

Hello,

Désolé, c'est user_source ou all_source ou dba_source. J'avais déjà débranché les trois cellules grises qu'il me reste :-)

desc user_source

select line,text from user_source where name='PACKCOLL';

Utilise user_source si tu fais un connect avec ADMIN sinon essaie

select line,text from all_source where name='PACKCOLL';

Vavavroum

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

Xavier.


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


> Salut,

> Comment trouver le user_code ??

> Car mon package s'appelle "PACKCOLL" et il a été créé par l'utilisateur

> ADMIN.

>

> Merci

>

> "Xavier Neys" <xavier.neys_at_12move.nl> a écrit dans le message news:

> 9od512$f2p$1_at_news1.xs4all.nl...

> > 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

> > >

> > >

> > >

> > >

> >

> >

>

>