apex读取文件

1、编写java类

import java.lang.String;
import java.io.File;
import java.io.FileReader;
import java.io.BufferedReader;
import java.io.IOException;
public class readfromfile {
public static String  readFileByLines(String fileName) throws IOException {
 
        File file = new File(fileName);
        BufferedReader reader = null;
            reader = new BufferedReader(new FileReader(file));
            String tempString = null;
            String lines="";
            while ((tempString = reader.readLine()) != null) {
                lines=lines+"<br/>"+tempString;
            }
            reader.close();
            return lines;
        }
}

2、编译java类

javac readfromfile.java

3、将java类导入到oracle中

loadjava -user 用户/密码  readfromfile.class

4、生成oracle函数

create or replace
function readlog(command varchar2) return varchar2 as language java name 'readfromfile.readFileByLines(java.lang.String) return java.lang.String';

5、查询

select readlog('/home/oracle/scripts/apex_exe_shell/test/sysstat.java') from dual;

6、在apex页面中调用oracle函数