Framework Manager BLOB Text limitation

[Yasser]

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,

[MFGF]

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.

[Yasser]

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 !

[MFGF]

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.

[Yasser]

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.

[Yasser]

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?

[Kiran P]

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

[bdbits]

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.