Skip to main content
Question

DataSource Designer with large SQL condition, ORA-06502

  • July 4, 2024
  • 1 reply
  • 52 views

ZIGESAMM
Do Gooder (Customer)
Forum|alt.badge.img+7

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
Sidekick (Employee)
Forum|alt.badge.img+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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings