SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using an update statement with CLOB column

612103Dec 5 2007 — edited Dec 5 2007

ALL,

I need to run the following query to help eradicate characters that are causing an application to fail. I am trying to get the query below to search a column and then update that column removing any characters outside of the last > in the clob

UPDATE TEST_VH_MASK SET MASK =SUBSTR(MASK,0,LENGTH(MASK)-1) WHERE SUBSTR(MASK,LENGTH(MASK),1) <> '>'

The error I get is ORA-00932 inconsistent datatypes

I have been trying to get my head around this for days and I have looked at the PLSQL procedure for DBMS_LOB but I have to admit that I am not to confident with PLSQL.

Any help you can offer solving the above would be greatly appreciated, I am happy to provide any further information

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 2 2008

Added on Dec 5 2007

3 comments

16,716 views