• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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!