[cisco-voip] Problems with DB Write and Update

[Denis Pointer]

Hello Again,
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:

update esc_case
     set
            resolution_desc    = 'Call dropped while in IVR/ACD'
           ,first_contact_resln_ind = 'N'
     where
           esc_case_id = $escCaseID ;

when I debug the script I get the following error on the write:

*null nested exception is:*
*java.lang.ArrayIndexOutOfBounds Exception*


I am able to to select with this variable doing select <stuff> from <table>
where esc_case_id = $escCaseID ; and it works fine

I have confirmed the variable types match (both are double)

If I hard code the esc_case_id and do the command as the following it works
fine:

update esc_case
     set
            resolution_desc    = 'Call dropped while in IVR/ACD'
           ,first_contact_resln_ind = 'N'
     where
           esc_case_id = 1180 ;


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


we have tried numerous variations of this command including update
<schema>.esc_case ..... etc. and always with the same results.

Thanks in advance for any direction you can provide

-- 
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090818/b2952250/attachment.html>