RE: File size
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <Walid.Alkaakati@xxxxxxxxxxxxxxx>
- Date: Wed, 8 Dec 2004 06:37:44 -0800
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Tuesday, December 07, 2004 9:53 AM
To: Walid.Alkaakati@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx> 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>
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
