Hello,
I'm using Oracle DB and I have a CLOB column contain a huge text, When I take it to the framework manager and test it I got the following error:
XQE-DAT-0034 the number of characters in a text value in the query result exeeded the maximum of 32767
Is there any way to increase this limit ?
Thanks,
Quote from: Yasser on 17 Jan 2017 04:17:51 AM
Hello,
I'm using Oracle DB and I have a CLOB column contain a huge text, When I take it to the framework manager and test it I got the following error:
XQE-DAT-0034 the number of characters in a text value in the query result exeeded the maximum of 32767
Is there any way to increase this limit ?
Thanks,
Does this post help?
http://www.cognoise.com/index.php/topic,31956.0.html
MF.
Quote from: MFGF on 17 Jan 2017 05:59:05 AM
Does this post help?
http://www.cognoise.com/index.php/topic,31956.0.html
MF.
Thanks for your response MF,
The problem is that the text is more than 120k characters !
Quote from: Yasser on 17 Jan 2017 07:12:05 AM
Thanks for your response MF,
The problem is that the text is more than 120k characters !
Unfortunately you're not going to be able to show it all. Around 6k is the limit - as per the workaround.
MF.
Quote from: MFGF on 17 Jan 2017 09:28:44 AM
Unfortunately you're not going to be able to show it all. Around 6k is the limit - as per the workaround.
MF.
No problem, I will try to think in another direction.
I've tried the the workaround it is not working with me !!
I've a stored procedure returns a CLOB text of 60k character and I've inserted it in the FWM using the query
cast(substring([Oracle_DB].[SP1].[HTML] ,1,60000) as varchar(60000))
it is throwing me the following error !!
XQE-PLN-0286 The second argument to the 'cast' function is a character data type with a size that exceeds 65535.
Is there anything wrong with the query?
Quote from: Yasser on 18 Jan 2017 01:53:42 AM
I've tried the the workaround it is not working with me !!
I've a stored procedure returns a CLOB text of 60k character and I've inserted it in the FWM using the query
cast(substring([Oracle_DB].[SP1].[HTML] ,1,60000) as varchar(60000))
it is throwing me the following error !!
XQE-PLN-0286 The second argument to the 'cast' function is a character data type with a size that exceeds 65535.
Is there anything wrong with the query?
Hi
I am not very much familiar with oracle but in SQL server varchar supports only 8000 characters. What is the limit for varchar in oracle? Can you try with fewer characters
Thanks
Kiran
The Oracle limit is 4k. For SQL Server, a specific number of characters is limited to 8k but you can use varchar(max) to store strings of up to 2G.