UCCX DBRead Store Procedure

[moisesvo]

Hi team,

I am trying to exec one store procedure from uccx dbread step, but this send me to sql error.

My Sentence:

declare @result int;

exec @result = sptest $codigo

select 'result' = @result

Regards

[hemajosh · Accepted solution]

i would recommned you to take a look at below Url's once :

• https://supportforums.cisco.com/discussion/10819521/uccx-call-ms-sql-stored-procedure-db-read-or-java
• https://communities.cisco.com/message/76891

Also here is the CCX step reference guide which covers all DB steps in detail ( ( Section 2-180  Database steps )
http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/programming/guide/uccx851_step_ref.pdf

Still if you not able to resolve the issue , please share the following details :
1) What’s the exact SQL error you are getting. ?
2) Have you used the DB read step earlier to access the SP . Is the issue only coming after some recent upgrade ?
3) Is the normal SQL queries properly accessible via DB read step ?