PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/28/2015 11:44 AM by  thummel1
Info Set Error
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
08/28/2015 9:12 AM
    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:

    --
    08/28/2015 10:46 AM
    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
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    08/28/2015 11:44 AM
    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
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    08/28/2015 11:44 AM
    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.