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

UCCX 9.0.2 - DB Get is not return selected record set

Hello

We have uccx 9.0.2. trying to connect ORACLE 10g R2.

1) i have uploaded "ojdbc14.jar"

2) created dsn

3) Uccx Script Db Read step, connected... and the sql  is

Select FORM_STATUS from yyy.V_IVR_name1

where addresspostcode='670211'

4) DB Get step is not shows above selected view name, but its listing other tables name...

The connect string connect to base schema for example "xxx", but my views are created in another schema called"yyy".

so the above sql statement return rows in "DB read" step. but db get step is not..

Please advise.. it would be much appreciated.

Thanks and Regards,

Param

2 REPLIES

UCCX 9.0.2 - DB Get is not return selected record set

Hi,

I don't understand, is there a problem specifying the correct schema name in the JDBC URL?

G.

UCCX 9.0.2 - DB Get is not return selected record set

Hi Gergely

Thanks for the update… sorry I have not  mentioned clearly.. I’m trying to access oracle db View from UCCX script… not  the table.

I just read through UCCX admin guide and found that databse view or store procedure are not supported. Is it true.

The Database subsystem does not support database views or execute store procedures.

Please advise…

Rgds

Param

311
Views
0
Helpful
2
Replies
CreatePlease to create content