RE: File size

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Wed, 8 Dec 2004 06:37:44 -0800
Message-ID: <7F24308CD176594B8F14969D10C02C6C3B7C8B@exch-mail2.win.slac.stanford.edu>

If the file name and path are known, one can use utl_file.fgetattr to = get the size of the file. I believe this procedure was introduced with = Oracle 9.2. I have not personally used this procedure.

It is assumed the original poster knows about the "create directory" = command and its corresponding grants to expose the file to pl/sql.

Ian

PROCEDURE FGETATTR

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LOCATION                       VARCHAR2                IN
 FILENAME                       VARCHAR2                IN
 FEXISTS                        BOOLEAN                 OUT
 FILE_LENGTH                    NUMBER                  OUT
 BLOCK_SIZE                     BINARY_INTEGER          OUT=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, December 07, 2004 9:53 AM To: Walid.Alkaakati_at_astrolabeit.com
Cc: oracle-l digest users
Subject: Re: File size

If you mean "I need to find the size of a file that is external to the = database"
you will need to use Java.

Jared

On Tue, 7 Dec 2004 17:22:11 +0200, Walid Alkaakati <Walid.Alkaakati_at_astrolabeit.com> wrote:
>=20

> How are you List !

>=20

> Can you help Please ?

>=20

> I need to know how to get the size of a file from pl/sql >

>=20

> Thanks to your help>
> --
> http://www.freelists.org/webpage/oracle-l

>=20

--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 08 2004 - 08:37:29 CST