<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18783">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Can you send a script snippet?</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=denis.mailer@gmail.com href="mailto:denis.mailer@gmail.com">Denis
Pointer</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=Ask-icd-ivr-support@external.cisco.com
href="mailto:Ask-icd-ivr-support@external.cisco.com">Ask-icd-ivr-support@external.cisco.com</A>
; <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 18, 2009 8:07
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [cisco-voip] Problems with DB
Write and Update</DIV>
<DIV><BR></DIV>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>
<P>
<HR>
<P></P>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></BLOCKQUOTE></BODY></HTML>