CLOB in Oracle differs from CLOB

There are different types of CLOB and Clob in Oracle.

(oracle.jdbc.internal.OracleCallableStatement) Oraclecallablestatement can receive the CLOB data type,

(java.sql.CallableStatement) The CallableStatement can receive CLOB data types.

code example

Package

CREATE OR REPLACEPackage BODY cux_supp_approval_report_pkg isPROCEDURETest_lower_clob (p_parameter_idinch  Number, x_out_xml out CLOB) isL_temp_strVARCHAR2(32767);    L_temp_clob Clob; BEGINdbms_lob.createtemporary (X_out_xml, TRUE); L_TEMP_STR:= '<?xml version= "1.0" encoding= "GBK"?>' ||Fnd_global.newline; Dbms_lob.writeappend (Lob_loc=X_out_xml, Amount=Length (l_temp_str), buffer=l_temp_str); END; PROCEDURETest_upper_clob (p_parameter_idinch  Number, x_out_xml out CLOB) isL_temp_strVARCHAR2(32767);    L_temp_clob Clob; BEGINdbms_lob.createtemporary (X_out_xml, TRUE); L_TEMP_STR:= '<?xml version= "1.0" encoding= "GBK"?>' ||Fnd_global.newline; Dbms_lob.writeappend (Lob_loc=X_out_xml, Amount=Length (l_temp_str), buffer=l_temp_str); END; END;

CLOB in Oracle differs from CLOB