Re: selecting from all_objects

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!