Clob is not suitable for use with the UNIQUE integrity constraint

Asked By Mark E Ward 30 points N/A Posted on - 05/21/2014

Hi Whiz,

I got this error message when I try to run a query in the database. I do not understand where I went wrong. I tried to trap the root cause of this error but I cannot. Please guide me to resolve this error message. Is there any other method available to trap the error? Thanks a lot. Your help is great.

 

Warning

Query Error. Error content is as follows.Skip?

Execute error:-248

1’th line is not executed (error)

Error description:

The attribute domain “clob” is not suitable for use with the UNIQUE integrity constraint

• Status: Open
• Question Views: 461
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Nortan gabriel 5 points N/A #189967

Clob is not suitable for use with the UNIQUE integrity constraint

Hello,

 

Please review the characteristics of the “CLOB” data type. Review what it is used for, what its limitations are, and how it can be manipulated. Given the nature of CLOB you cannot work with it in the same way as many other data types. You must be much more aware of what is happening with it and where it is stored. This error is not the result of a simple syntax error, but rather how you are manipulating the data.

About Nortan gabriel

Questions
0

Answers
157

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/29/2015
• Question Category: Database