Result of string concatenation is too long

Eric Davis
edited February 11, 2022 in Analytics #1

I have a report that runs fine and produces the correct results. Also, the query runs fine in Toad and SQL+. The problem is that when I go into the dataset editor then close it, I receive an error (SQL error #1:ORA-01489: result of string concatenation is too long). Any suggestions?

Comments

  • The error is coming from the database. Can you check the database logs to see what query is causing the error? The query in the data set editor can be modified dynamically and the designer doesn't have a good way to check the exact query being sent to the DB.

    Warning No formatter is installed for the format ipb
  • Thanks Jeff, I just ran it again and now I am getting the error in toad and SQL+. I'll fix the query.