Prev
Next
Forums Performance Management Smart Notification

Infoset Query String errors out

 1 Replies
 1 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
8/21/2019 7:37 PM
    I have an SQL Statement that successfully runs in SQL Oracle, but when I add it as an Info set in the Smart Notification tool I receive the following error message: "Error: ORA-01756: quoted string not properly terminated".

    I have double quotes around all my column headers. I also have single quotes around any strings that are part of case statements. (e.g. case when x = 'ABC' then 'Pass' else 'Fail' end as "Test")

    My SQL is almost 2500 rows, with very complex case statements. Some strings in case statements will result in very large strings (one example is 520 characters).(e.g. case when x = 'ABC' then '520 character result' else 'Fail' end as "Test")


    Question: What are some of the causes that would result in this error? Obviously if I am missing a quotation somewhere I can understand, but I am not, so I wonder if functionality within an Info Set does not align with functionality of SQL for Oracle? Are there limits on character lengths that I'll need to account for when writing my schema?

    thummel1
    Veteran Member
    Posts: 121
    Veteran Member
    8/21/2019 8:50 PM
      I found an answer to my own question, so for those interested here was my solution. In some single quotes within my case statements there were symbols such as dollar signs, semi-colons, colons, asterisks...I remove anything like that and my info set executed and the notification delivered to me successfully.