Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

DB Read error from UCCX Script

Hi All,

We are running uccx 7.0.

      

Trying to return data from DB using stored procedure from the uccx script.

We are able to run this when we pass explicit value instead of variable ANI.

But whenever we provide variable ANI, we get below

error: SQL statement varible not defined : ANI

Query which provided in the DB Read as below,

select * from  table(credit_back.fun_select_point($ANI));

Request your help on it..

Regards,

Shalid K.C

7 REPLIES

DB Read error from UCCX Script

Hi,

okay, is there a variable named ANI and of the correct type?

G.

DB Read error from UCCX Script

Thank you Gerely for the response..

we have defined the variable ANI as string in the uccx script and it is also declared in procedure as well..

Regards,

Shalid K.C

DB Read error from UCCX Script

And does it have a value? Did you try running the script in reactive mode?

G.

DB Read error from UCCX Script

Yes Gergely.

we have created new script and when i add DB Read function in the script, it is not allow to apply it, same time it is giveing the above mentioned error.

but when i test it with explicite value it is working.. .not working by providing variable name

Regards,

Shalid

New Member

Hi,I know it was a long time

Hi,

I know it was a long time ago but where you able to resolve this issue, I'm having kind of the same issue now.
this is my query

select * from Contractor_Pre_Auth where Contractor_Phone like '%$ANI%'

 

thank you

Xtian

Hi,can you try the following

Hi,

can you try the following:

select * from Contractor_Pre_Auth where Contractor_Phone like '%' + $ANI + '%'

Essentially, it's the same command.

G.

New Member

 Did work, thankyou so much. 

 

Did work, thankyou so much.

 

-X

306
Views
5
Helpful
7
Replies
CreatePlease login to create content