Hello Again,<div><br></div><div>I am doing an integration with UCCX 7.01SR3 and Oracle 10g. I am able to successfully do DB reads and DB writes to select and insert data into a few different tables, The problem I am having now is with a DBWrite doing an update. The update command we are using is:</div>
<div><br></div><div><div>update esc_case </div><div> set</div><div> resolution_desc = 'Call dropped while in IVR/ACD'</div><div> ,first_contact_resln_ind = 'N'</div><div> where</div>
<div> esc_case_id = $escCaseID ;</div><div><br></div><div>when I debug the script I get the following error on the write:</div><div><br></div><div><b>null nested exception is:</b></div><div><b>java.lang.ArrayIndexOutOfBounds Exception</b></div>
<div><br></div><div><br></div><div><div>I am able to to select with this variable doing select <stuff> from <table> where esc_case_id = $escCaseID ; and it works fine</div><div><br></div><div>I have confirmed the variable types match (both are double)</div>
<div><br></div><div>If I hard code the esc_case_id and do the command as the following it works fine:</div><div><br></div><div><div>update esc_case </div><div> set</div><div> resolution_desc = 'Call dropped while in IVR/ACD'</div>
<div> ,first_contact_resln_ind = 'N'</div><div> where</div><div> esc_case_id = 1180 ;</div></div><div><br></div></div><div><br></div><div>Any idea why it is failing when I try and do the update using the variable? During the debug the variable is showing as, for example, 1180.0D</div>
<div><br></div><div><br></div><div>we have tried numerous variations of this command including update <schema>.esc_case ..... etc. and always with the same results.</div><div><br></div><div>Thanks in advance for any direction you can provide</div>
<div><br></div>-- <br>Denis Pointer, A. Sc. T.<br>Customer Systems Analyst (Senior Design)<br><br>CCVP, CCNA, CCDA<br>Cisco Unified Contact Center Specialist<br>
Cisco IP Telephony Design Specialist<br>Cisco Unity Design Specialist<br>Cisco Unity Support Specialist<br>Cisco IP Communications Express Specialist<br>
</div>