Implicit conversion between CLOB and NCLOB object
SQL> CREATE TABLE nmyTable (
2 id INTEGER PRIMARY KEY,
3 nclobData NCLOB
4 );
Table created.
SQL> CREATE TABLE myTable (
2 id INTEGER PRIMARY KEY,
3 clobData CLOB
4 );
Table created.
SQL>
SQL> CREATE OR REPLACE TRIGGER before_myTable_update
2 BEFORE UPDATE
3 ON myTable
4 FOR EACH ROW
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE('myTable changed');
7 DBMS_OUTPUT.PUT_LINE('Length = ' || DBMS_LOB.GETLENGTH(:new.clobData));
8 END before_myTable_update;
9 /
Trigger created.
SQL>
SQL> drop table myTable;
Table dropped.
SQL> drop table nmyTable;
Table dropped.
Related examples in the same category