[cisco-voip] DB Read step with no return values

[Kevin Damisch]

Has anyone written a script (UCCX 8.x in my case) where the DB Read step is only used to run a stored procedure on a remote SQL server, but there is no need to return any values back to the script, nor does it send anything back.  Typically, we use the DB Read/DB Get steps together to get the data back by mapping to a dummy table on their SQL server, but in this case, the stored procedure returns absolutely nothing.  When the script gets to this DB Read step, it always takes the SQL Error branch.  Packet captures do not show any SQL errors being returned, which leads me to believe that the DB Read step needs to have at least "something" returned back from the SQL server.  Can anyone confirm if the DB Read step is required to get some type of data returned to the script from the SQL server?

The issue we have is that the stored procedure code on the SQL server really can't be changed to return back some type of success/failure value.

Thanks,
Kevin

________________________________

This communication (including any attachments) is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify Vital Support Systems at 515 334 5700 and delete or destroy all copies and the original document.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120605/55ee391e/attachment.html>