PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 8/28/2015 3:44 PM by  thummel1
Info Set Error
 3 Replies
 2 Subscribed to this topic
 71 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(219 points)
Veteran Member
Posts:121


Send Message:

--
8/28/2015 1:12 PM
    Hi,

    I built a query that contains a sub-query in SQL Developer. The query executes just fine in SQL Developer. When I paste this SQL into my Info Set in LBI TEST, I get this screen that prompts that says "enter parameter values" and contains multiple rows of the data fields that are in my headers. I don't have any parameters build into my SQL so I am not sure what in my SQL could trigger this message prompt. I tried to attached a word doc of the error as well as

    Any suggestions are appreciated. Thanks!
    The.Sam.Groves
    Programmer Analyst
    St Lukes Hospital
    Veteran Member
    (265 points)
    Veteran Member
    Posts:89


    Send Message:

    --
    8/28/2015 2:46 PM
    Does your query include any square brackets? For instance, anything like this?
    REGEXP_LIKE(emp_status,'[AL]{1}[0-9]{1}','i')

    LBI uses [name] to define a parameter in an infoset. Which completely screws up any SQL written to take advantage of regular expressions. I have no solution to the problem other than re-writing the SQL in a way that avoids this.
    thummel1
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (219 points)
    Veteran Member
    Posts:121


    Send Message:

    --
    8/28/2015 3:44 PM
    Thanks, Yes I do! Right here: [TERM_DATE]>{ts '1799-01-01 00:00:00'}
    in my Where clause. I will try to change this to something that works.

    Thank you!
    thummel1
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (219 points)
    Veteran Member
    Posts:121


    Send Message:

    --
    8/28/2015 3:44 PM
    Thanks, Yes I do! Right here: [TERM_DATE]>{ts '1799-01-01 00:00:00'}
    in my Where clause. I will try to change this to something that works.

    Thank you!
    You are not authorized to post a reply.