DB Read error from UCCX Script

[Shalid Kurunnan Chalil]

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

[Gergely Szabo]

Hi,

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

G.

[Shalid Kurunnan Chalil]

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

[Gergely Szabo]

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

G.

[Shalid Kurunnan Chalil]

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

[christian galdos]

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

[Gergely Szabo]

Hi,

can you try the following:

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

Essentially, it's the same command.

G.

[christian galdos]

Did work, thankyou so much.

-X