I am trying to get the trigger_body column (long) into a pl sql varible(long) and am getting character string buffer too small. The text of the body of the trigger is approaching 32767 mark or whatever, so i tried varchar2(4000). Still having the same error.

My goal is to get the text into the varible so i can do a compare with the same dba_triggers table in another database. This seems to work, however i cannont get past the hurdel of getting that text into a form that i can do a compare, as the program blows up at this point.

Any suggestsions are greatly appreciated. THanks in advance!