Hi again Doug.

A different idea: I'm looking at this bit of the Oracle::DBD docs: "One further wrinkle: for inserts and updates of LOBs, DBD::Oracle has to be able to tell which parameters relate to which table fields. In all cases where it can possibly work it out for itself, it does, however, if there are multiple LOB fields of the same type in the table then you need to tell it which field each LOB param relates to"

Although if that was the problem then it would be really weird for it to work as one user but not as another - but maybe the aliases are screwing things up somehow. Does it help if you use

$sth->bind_param($idx, $value, { ora_type=>ORA_CLOB, ora_field=>'foo' });

?

HTH, andye