Re: UTL_FILE?

From: <owais_anjum_at_my-deja.com>
Date: Tue, 07 Sep 1999 12:52:56 GMT
Message-ID: <7r31r3$ds9$1@nnrp1.deja.com>

In article <37D4CD36.B34A0A5_at_eexi.gr>,
kkons_at_intrasoft.gr wrote:
> Could anyone tell me where is the above package? (UTL_FILE) because I
> can't locate it.Which is the difference between this one and TEXT_IO
> package?
>
>

Hello

All the packages are owned by SYS user, but the others users do have a priviledge to view and use these packages (unless otherwise specified). You should be able to see its definition by issuing the following command from any user

SQL> desc utl_file.fopen
FUNCTION utl_file.fopen RETURNS RECORD

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
   ID                           BINARY_INTEGER          OUT
 LOCATION                       VARCHAR2                IN
 FILENAME                       VARCHAR2                IN
 OPEN_MODE                      VARCHAR2                IN

If it is still not visible, then go to
ORACLE_HOME\orant\rdbms80\admin\utlfile.sql

Execute this script from SYS user and it will generate the package for you.
Hope it helps

Owais

Note: The path may vary depending upon the version of Oracle that you are using.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 07:52:56 CDT