The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

Result of string concatenation is too long

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?


  • 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.

    Jeff F.
    Sr. Technical Support Specialist
  • Thanks Jeff, I just ran it again and now I am getting the error in toad and SQL+. I'll fix the query.

Sign In or Register to comment.