using CLOB

Guys

I'm working on one DB monitoring Blocking sessions which capture sessions details including SQLCODE of the session caused the blocking lock and for that we were been using a table with different columns and for SQLCODE was used a column varchar2 ( 4000 bytes). So as we noticed it was not enough due sometimes the SQLCODE is bigger than that we used

We changed from this

CREATE TABLE DBSNMP.DBLOCKS_DETAILS

(

  SID_NUM       NUMBER(10),

  SESS_NUM      NUMBER(10),

  DBUSER_NAME   VARCHAR2(50 BYTE),

  NODE_NAME     VARCHAR2(64 BYTE),

  OSUSER_NAME   VARCHAR2(50 BYTE),

  PID           VARCHAR2(12 BYTE),

  PROGRAM_DETL  VARCHAR2(75 BYTE),

  WAIT_TIME     NUMBER(25),

  EVENTDATE     DATE,