Q
Problem solve Get help with specific problems with your technologies, process and projects.

Data truncated after 4,000 characters

You have given an answer to the following question: "Is it possible to do a UNION of two Oracles 8i views where there are CLOB fields involved?" But I found that the data is getting truncated after 4,000 characters if I follow your suggestion.

You have given an answer to the following question: "Is it possible to do a UNION of two Oracles 8i views where there are CLOB fields involved?" But I found that the data is getting truncated after 4,000 characters if I follow your suggestion. Can you tell me another way so that I will not lose any data even after 4,000 characters?

The UNION operator, as we have seen, does not like the CLOB datatype. My solution was to convert the CLOB datatype to VARCHAR2 which has a 4,000-character limit. So you will not be able to UNION two views and obtain more than 4,000 characters from the CLOB column.

One thing you can do is to pull the CLOB values from the views in a subsequent operation. But this will have to be performed without the UNION operator.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close