thummel1Data Analyst II Fairview Health Services  (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.GrovesProgrammer Analyst St Lukes Hospital (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.
|
|
|
|
thummel1Data Analyst II Fairview Health Services (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!
|
|
|
|
thummel1Data Analyst II Fairview Health Services (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!
|
|
|
|