I recently struggled with a similar situation, but I was connecting to MS SQL Server. My method of resolution may work for you.
1. Create a stored procedure in Oracle that you can call with the variable as input.
2. Create a dummy table that has a single field in it called Employee_ID. This field should be of the same data type and length as the Employee_ID field in the table ABC mentioned in your original query. You're not going to put data here, but you do need it for the schema.
3. Execute the stored procedure with a DB Read.
4. Then execute the DB Get step. Point it at the dummy table that you created. You have to do this because IPCC can't handle cursors from stored procedures. What we are doing is giving it the table to use as a schema for the results.
This same thing happened to me a week ago, and this is how I fixed it.
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...