PL/SQL packages HELP?

Hello,
After hours of frustration I have decided it is time to consult the collective net-knowledge on the following (probably trivial) problem:

I am using the Procedure Builder to write a PL/SQL package which I am storing as a database object. From within this package I want to refer to the standard built in packages, specifically TEXT_IO.

Currently I refer to the contents of this package thusly:

TEXT_IO.FILE_TYPE for instance. However the compiler does not like this when I use it from a stored DB package, or stored Program unit - though it is OK from a non-sored package or unit.

I'm sure there is a simple and obvious reason for this and a solution for it - I just can't find it!

Any ideas gratefully recieved, preferably by email (djcunlif_at_glam.ac.uk)

Thanks in advance,

Daniel. Received on Wed Mar 06 1996 - 00:00:00 CET