title: How do I get the trigger_body from the user-triggers table in C#
body: <p>Background: I'm actually trying to identify autoincrement columns in an Oracle table from a C# program. I have already discovered that in Oracle autoincrement is done using a sequence and a trigger, and have identified the sequences and triggers in an example database using SQL Developer.</p>
  
  <p>So, next step, get the triggers: this I can do with a query - "Select * from USER_TRIGGERS". No problem. There is even a TABLE_NAME field to check against the table I want to examine. (There is also a COLUMN_NAME column which might be useful, but that always seems to be empty).</p>
  
  <p>Now there seems to be no alternative but to parse the TRIGGER_BODY field - but there's the rub. SQL Developer shows me that there is a meaningful-looking string in TRIGGER_BODY, but in my DataTable, returned from the query, the TRIGGER_BODY field is always blank.</p>
  
  <p>I've hunted around on the web, and it seems that TRIGGER_BODY is in fact a LONG, although C# says the column is of type string, so I don't understand that. The only suggestion I've found so far is to use the TO_LOB() (or possibly TO_CLOB()) function to somehow convert the contents of the field, however that just throws an "inconsistent datatypes" exception.</p>
  
  <p>I'm using C# 4.5, and Oracle.DataAccess for the data access objects. Oracle is at Version 11g.</p>
  
  <p>Any suggestions would be gratefully received.</p>