Cannot define index on domain “clob”

Asked By Stephen R Gates 50 points N/A Posted on - 05/21/2014

Hello 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. It says the error is in the line 269, but not able to find it. 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:-269

1’th line is not executed (error)

Error description:

Cannot define index on domain “clob”.

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

• Answer Accepted: No
• Question Category: Database

Answered By Nortan gabriel 5 points N/A #190036

Cannot define index on domain “clob”

Hello,

 

The error may be the result of the system being configured to create a domain index on a temporary table. It could also be the result of the data type, CLOB, not being managed and stored properly. Examine the data you are working with more closely. Also, review your syntax and ensure you are using appropriate syntax and entries for CLOB data.

About Nortan gabriel

Questions
0

Answers
157

Best Answers
1

• Vote Up 0 Vote Down

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