Home » SQL & PL/SQL » SQL & PL/SQL » File size
File size [message #35792] Tue, 16 October 2001 07:36 Go to next message
jeje
Messages: 9
Registered: October 2001
Junior Member
I need the size of a flat file with PL/SQL procedure.

Can you help me.

----------------------------------------------------------------------
Re: File size [message #35801 is a reply to message #35792] Tue, 16 October 2001 10:24 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Create java stored procedure. ( you need some privileges to create java stored procedure).

create or replace and compile
java source named "Jsize"
as

import java.io.File;
public class Jsize {
public static long length (String fileName) {
File myFile = new File (fileName);
return myFile.length();
}
}
/
CREATE OR REPLACE FUNCTION filesize
(file IN VARCHAR2)
RETURN NUMBER
AS LANGUAGE JAVA
NAME 'Jsize.length (java.lang.String)
return long';
/

declare
n number;
begin
n := filesize('&filename');
dbms_output.put_line(n);
end;

/

Suresh home page

----------------------------------------------------------------------
Re: File size [message #35805 is a reply to message #35801] Tue, 16 October 2001 12:06 Go to previous message
jeje
Messages: 9
Registered: October 2001
Junior Member
Sorry, java is't available here. If you know something else...

Thanks..

----------------------------------------------------------------------
Previous Topic: Table Lock
Next Topic: Re: Table Lock
Goto Forum:
  


Current Time: Thu Mar 28 18:26:31 CDT 2024