Use DBMS_OUTPUT.PUT_LINE to output clob data : dbms_output « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. dbms_output

Use DBMS_OUTPUT.PUT_LINE to output clob data

  

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 PROCEDURE nclob_example
  2  AS
  3    clobVariable CLOB := 'It is the east and Juliet is the sun';
  4    nclobVariable NCLOB;
  5  BEGIN
  6    INSERT INTO nmyTable (id, nclobData) VALUES (1, clobVariable);
  7
  8    SELECT nclobData INTO clobVariable FROM nmyTable WHERE id = 1;
  9
 10    DBMS_OUTPUT.PUT_LINE('clobVariable = ' || clobVariable);
 11  END nclob_example;
 12  /

Procedure created.

SQL>
SQL> drop table myTable;

Table dropped.

SQL> drop table nmyTable;

Table dropped.

   
    
  

Related examples in the same category