-- "Reidy, Ron" <[EMAIL PROTECTED]>

Steve,

See the DBD::Oracle docs, section "Handling LOBs". Basically, you need to
insert a EMPTY_CLOB(), return the locator, and then call ora_write_lob()
to push the data into the locator.

This is a generic query handler. In order to do that I have to
investigate the data type of each '?' in the input sql, determine
if it is a LOB, and handle that field specially. If there were
something like convert for a clob then I could push the knowlege
of clob-ness up into the SQL.

This code is also used for other databases (e.g., MySQL, which
handles text fields more gracefully).

--
Steven Lembark                                       85-09 90th Street
Workhorse Computing                                Woodhaven, NY 11421
[EMAIL PROTECTED]                                     1 888 359 3508

Reply via email to