SQL> CREATE TABLE myTable (
2 id INTEGER PRIMARY KEY,
3 clobData CLOB NOT NULL
4 );
Table created.
SQL>
SQL> CREATE OR REPLACE PROCEDURE compare_example IS
2 clobVariable1 CLOB;
3 clobVariable2 CLOB;
4 return_var INTEGER;
5 BEGIN
6 SELECT clobData INTO clobVariable1 FROM myTable WHERE id = 1;
7 SELECT clobData INTO clobVariable2 FROM myTable WHERE id = 2;
8
9 return_var := DBMS_LOB.COMPARE(clobVariable1, clobVariable2);
10 DBMS_OUTPUT.PUT_LINE('return_var = ' || return_var);
11
12 return_var := DBMS_LOB.COMPARE(clobVariable1, clobVariable1);
13 DBMS_OUTPUT.PUT_LINE('return_var = ' || return_var);
14 END compare_example;
15 /
Procedure created.
SQL>
SQL> drop table myTable;
Table dropped.