03-13-2024 03:08 AM - edited 03-13-2024 03:29 AM
My customer has a procedure in their DB to lookup the validity of credentials provided via IVR - from MS SQL Studio calling that procedure works as expected, but when i paste the same code in the DB Read step, Testing it returns 0 rows and running it shows an SQL Error.
I found another post with stored procedures and someone there said that UCCX probably doesnt support procedures (https://community.cisco.com/t5/contact-center/uccx-script-sql-error-on-db-write/td-p/4779924)
EDIT: I followed the info in this thread (https://community.cisco.com/t5/contact-center/uccx-call-to-a-ms-sql-stored-procedure-in-db-read-or-java/td-p/1348969) and testing the DB Read now returns a row - but i could not find anywhere on how to actually retrieve the returned value in the DB Get step, as it isnt in any of the tables i can select in the DB Get?
is this true?
Solved! Go to Solution.
05-02-2024 09:09 AM
You can use a stored procedure, but you are correct that you have to work a little to retreive the values. The way I have done it is by creating a blank table in the database that just contains the schema (i.e. fields and data types) of what your stored procedure results will be. Use that table to identify what to pull back. Works like a charm.
03-13-2024 03:38 AM
UCCX dosn't support stored procedures in there DB steps - sorry
05-02-2024 09:09 AM
You can use a stored procedure, but you are correct that you have to work a little to retreive the values. The way I have done it is by creating a blank table in the database that just contains the schema (i.e. fields and data types) of what your stored procedure results will be. Use that table to identify what to pull back. Works like a charm.
05-02-2024 09:46 AM
That is a creative solution, I wish I had thought of that!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide