08-27-2013 02:22 AM - edited 03-14-2019 12:19 PM
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
08-27-2013 03:10 AM
Hi,
okay, is there a variable named ANI and of the correct type?
G.
08-27-2013 03:53 AM
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
08-27-2013 03:55 AM
And does it have a value? Did you try running the script in reactive mode?
G.
08-27-2013 04:18 AM
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
03-19-2015 01:46 PM
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
03-20-2015 12:36 AM
Hi,
can you try the following:
select * from Contractor_Pre_Auth where Contractor_Phone like '%' + $ANI + '%'
Essentially, it's the same command.
G.
03-20-2015 05:41 AM
Did work, thankyou so much.
-X
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