Re: PL/SQL packages HELP?
Date: 1996/03/06
Message-ID: <4hkbn9$ej4_at_inet-nntp-gw-1.us.oracle.com>#1/1
TEXT_IO is available only on the client side (eg: in a forms 4.5 application). It becomes available on the server with version 7.3 of the database. Thats why you can't store the object in the database, text_io is not supported there yet.
Daniel Cunliffe <djcunlif_at_glam.ac.uk> wrote:
>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.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
opinions and statements are mine and do not necessarily reflect the opinions of Oracle Corporation. Received on Wed Mar 06 1996 - 00:00:00 CET