For the clobs, your best bet is to use a cfqueryparam on the insert. Of course, that screws up the idea of using cfinsert. You can figure out what the fields were though with a little data dictionary query.
<cfquery name="gettabs"....> select table_name, column_name, data_type, data_length, data_scale, nullable from cols order by table_name </cfquery> On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote: > How'd I make that mistake?? you're right of course - they are indeed CLOBs. > > >Oracle BLOBS are binary, not text - they are going to break if you put > >them in a text field. Are you sure you don't mean CLOBs? > > > >On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4