IPCC Express 4.0.4 HA
We have some situation going here when we fire query with Oracle.
I will explain in Details.
Customer has three types of Employees
1. Contractors - starting with x followed by six numberic digits e.g x0124567
2. Suppliers - Starting with s than followed by six digits e.g s0124567
3. Regular Employees- just six digit numeric number. e.g 123456
Now while doing the testing part we created Test Database in SQL and created a table with employee details.
And in script we are asking emoployee press 1 if you are regular employee, press 2 if you are contractor, press 3 if you are supplier.
If someone press 2
And in DB read node we have defined this query.
Select Employee_ID from ABC where Employee_ID like 'x%' + '%' + $Emp_Num(Emp_Num is local variable in which we are storing employee input)
This all works well and fine with SQL and we dont have any issues with supplier or Regular employee as well.
But now we are trying to integrate our IPCC with Oracle database(Actual Database).
We are running this Query.
Select Employee_ID from ABC where Employee_ID like 'x%' and Employee_ID like '%0124567'
This query runs fine. But the moment we put Emp_Num variable instead of static value we see in debug that while reading database call is going to No Data node of DB read instead of Success.
We are really not sure whats happening we have tried lots of permutations and combinations with the query but the query seems to be not working for us at all.
Guys we need this really badly. If someone can help in this we will really appreciate.