Hi, I have a CLOB question.
I have the follwoing Java Code from the Web:
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED TESTJAVA as import java.io.*;
import java.sql.Connection;
import oracle.jdbc.driver.*;
import oracle.sql.CLOB;
public class TESTJAVA {
public static CLOB clobTest(String inputString) throws java.sql.SQLException {
OracleDriver driver = new OracleDriver();
Connection conn = driver.defaultConnection();
CLOB clob = CLOB.createTemporary(conn, false, CLOB.DURATION_CALL);
clob.setString(1, inputString);
//CLOB.freeTemporary(clob); // <--- ??
return clob;
}
}
The question ist about "CLOB.freeTemporary(clob);"
In this case it doesn't make sense to do it before the return statement. And because of a compile-time error I can not do it after the return statement.
Am I completly wrong with this if I want to return a CLOB?
Thanks,
rrr