Skip to main content

Hello,

we have a created a datasource with a large text in condition field. We get the Error 

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The Preview with the large sql works as expected. But when trying to save the Datasource in IEE we get the abouve message.

Is there a way to increase the string buffer and use the large sql in the Lobby Element?

Hi @ZIGESAMM , The whole statement has total of 4000 character limit including SELECT, WHERE, GROUP BY, ORDER BY. Therefore, its better to use a Database view to reduce the query length.

Reply


Terms & ConditionsCookie settings