Prev
Next
Forums Performance Management Smart Notification

Info Set Error

 3 Replies
 2 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
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
    Veteran Member
    Posts: 89
    Veteran Member
    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
      Veteran Member
      Posts: 121
      Veteran Member
      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
        Veteran Member
        Posts: 121
        Veteran Member
        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!