Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: packages
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
> >
> >
> >
> >
>
>
Received on Fri Sep 21 2001 - 02:17:32 CDT