Implicit conversion between CLOB and NCLOB object : nclob « Data Type « Oracle PL / SQL






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

1.nclobData type