We are trying to connect to an Oracle Database with UCCX version 8. We had the client upgrade their version of Oracle to 11g R2 which is on the UCCX compatibility chart. The problem that we have run into is that Oracle is expecting single quotes for the query. It seems that UCCX only sends query strings with double quotes. For example, my queries to Oracle only work if I hardcode the values for example '1234567' . If I try to use a variable it does not work. I've done this before with SQL and DB2. Does anyone know what the trick is to get this to work with Oracle? Thanks
