PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/21/2019 4:50 PM by  thummel1
Infoset Query String errors out
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(213 points)
Veteran Member
Posts:117


Send Message:

--
08/21/2019 3: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
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (213 points)
    Veteran Member
    Posts:117


    Send Message:

    --
    08/21/2019 4: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.
    You are not authorized to post a reply.