Clob is not suitable for use with the UNIQUE integrity constraint

Asked By 30 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #189967

Clob is not suitable for use with the UNIQUE integrity constraint

qa-featured

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.

Login/Register to Answer

Related Questions