| File size [message #35792] |
Tue, 16 October 2001 07:36  |
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  |
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 |
jeje
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
Sorry, java is't available here. If you know something else...
Thanks..
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
