Re: utl_file

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 20 Jun 2006 10:22:37 -0700
Message-ID: <1150824157.379631.56320@c74g2000cwc.googlegroups.com>

sarvan wrote:
> hi
> why dont u try TEXT_IO package,thoiugh it writes /reads client try it
> out onserver it will work.
>
> regards
> sarvan
> pawan_test wrote:
> > Hi all,
> >
> > i have a oracle procedure. it uses the Oracle supplied package UTL_FILE
> > to read and write files that are located on the server.
> >
> > is there any other oracle supplied package available to read or writes
> > files. if there is not such package available then can anyone please
> > suggest me if there is any other alternate method available in oracle
> > to read and writes files on the server.
> >
> > Thanks
> > pavi

What is TEXT_IO?

SQL> show user
USER is "SYS"
SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production NLSRTL Version 10.2.0.2.0 - Production

SQL> select object_name from all_objects where object_name = 'TEXT_IO';

no rows selected

Regards
/Rauf Received on Tue Jun 20 2006 - 12:22:37 CDT