Skip to main content
Question

DataSource Designer with large SQL condition, ORA-06502

  • 4 July 2024
  • 1 reply
  • 20 views

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?

1 reply

Shehan Chandrasekara
Rank
Userlevel 4
Badge +8

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