Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java Stored Procedure and CLOB

I_love_bitsMay 20 2019 — edited Aug 6 2019

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

Comments

Post Details

Added on May 20 2019
1 comment
951 views