UCCX Stored Procedure

Unanswered Question
BCOLE2007 Thu, 07/24/2008 - 09:18
User Badges:
  • Bronze, 100 points or more

Hi Hunt,


Their are some tricks that can be pulled off to call stored procedures with the Database Steps, I believe in SQL server, the Exec command can be used in a DBRead, I have not done this but seen posts talking about it, I went down the same road with PL/SQL on Oracle.


let me suggest that you write a Java class to call the stored procedure, if you know Java this may be the way to go.



peyjremario176 Fri, 01/09/2009 - 21:31
User Badges:

I believe its also posible.I just like to know if there's somebody tried it succesfully.I have created stored procedure for custom report to get rid of any 4 digit ANI to be counted on my report the use CRS historical reporting but i was unsucessful as of the moment. I actually copy the getTotalCall stored procedure then modified it with additional ccdr.LEN(originatorDN) > 4 the created it stored procedure with new name.

Actions

This Discussion