RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
-- "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
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
lembark@xxxxxxxxxxx 1 888 359 3508
.
