Package Wizard empty generated units.

Druching

Member
Hi. I have a little problem here. Not so far we have moved our base to oracle 11g from 10g. And now we have one on 11g and one on 10g for tests. When i generate units whith Package wizard (PW) on 10g i have no problems. Result units is fully correct. But when i try to generate the same on 11g on Step 3 in PW I've got an empty list. And then i've got unit with no procedures or funcions. Actually unit is not clear. It contains commented interface block of package. And class declaration:
TSpInterface = class(TOracleCustomPackage)
public
published
property Name;
property Session;
property Cursor;
end;
It seems like PW doesn't see a body of package. Can you help me? What can i do in this case?
 
That is odd. Perhaps the package specification is wrapped? What do you see when you execute the following query?

Code:
select text
from  all_source s
where s.owner = '<OWNER>'
and   s.name = '<PACKAGE NAME>'
and   s.type = 'PACKAGE'
order by s.line
 
The problem is privileges. Base admin gived grantable privilegies on packege to me and problem was solved. Any way, thank you.
 
Back
Top