Forum OpenACS Development: Re: 'ORA-00932: inconsistent datatypes' error on Oracle 8.1.7.0.1

Not sure if I understand the question correctly, but I would try to use the DBMS_LOB package, specifically the DBMS_LOB.GETLENGTH and DBMS_LOB.INSTR functions. Documentation can be found on Oracle OTN.