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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

15,945 views