稍微改了下，目前全部完整代码和错误信息如下：
----test函数----
create or replace function test(url varchar2) return LONG RAW as
language java name 'RemoteFileObject.getRemoteFileObject(java.lang.String) return byte[]';
---oracle java source---
create or replace and compile java source named remotefilemanager as
import java.io.BufferedInputStream;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.net.URI;
import java.net.URLConnection;
public class RemoteFileObject {
public static byte[] getRemoteFileObject(String urlPath) {
String ret = "";
byte[] datas = null;
URI uri = null;
URLConnection connection = null;
BufferedInputStream in = null;
ByteArrayOutputStream out = null;
try {
uri = new URI(urlPath);
connection = uri.toURL().openConnection();
in = new BufferedInputStream(connection.getInputStream());
out = new ByteArrayOutputStream();
byte[] buffer = new byte[1024];
int len;
while ((len = in.read(buffer)) != -1) {
out.write(buffer, 0, len);
}
datas = out.toByteArray();
// ret = new String(datas, "ISO-8859-1");
} catch (Exception e) {
e.printStackTrace();
} finally {
if (in != null) {
try {
in.close();
} catch (IOException e) {
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
}
}
}
return datas;
//return ret;
}
}
-----java应用程序----
public static void main(String[] args) {
Connection conn = null;
String fname = "test.jpg";
String url = "http://localhost:8080/" + fname;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:cweb", "dcm", "dcm");
CallableStatement cs;
cs = conn.prepareCall("{? = call test(?)}");
cs.registerOutParameter(1, Types.LONGVARBINARY);
cs.setString(2, url);//http://172.19.31.229:7001/tgtpApp/images/ico1.png
cs.execute();
byte[] bytes = cs.getBytes(1);
System.out.println(bytes.length);
} catch (Exception e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
}
}
}
}
出错信息：
java.sql.SQLException: ORA-24345: 出现截断或空读取错误
ORA-06512: 在 "DCM.TEST", line 1
ORA-06512: 在 line 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:212)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:951)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4223)
at MainJavaSource.main(MainJavaSource.java:63)
