Firends,
I do not think the problem is the actual code.
If I execute the select SQL which selects the package body, it will work,
and I can see all the code, but when I create a procedure to do the job, it
does not work.
However the procedure can extract the package Spec.
So I think there musy be some issue with oracle security which does not
allow you to view pakage body within a stored procedure.
Tom
alexjunq <alexjunqNOalSPAM_at_softwaredesign.com.br.invalid> wrote in message
news:1916ff1c.9ee131ea_at_usw-ex0103-024.remarq.com...
> Hello Tom,
>
> taking a look at your code:
>
> (...)
> select
> a.text
> from
> all_source a
> where
> a.OWNER = upper(v_user)
> and a.name = v_pack_name
> and a.TYPE = 'PACKAGE BODY'
> order by a.line)
> (...)
>
> Are you sure you're passing package name (v_pack_name) in
> upper case?? If you're not it'll be necessary use an
> upper(v_pack_name) in your statement as you do for
> object's owner.
>
> Regards
>
> Alexandre Junqueira
>
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Wed Mar 08 2000 - 16:33:19 CST
