[cisco-voip] Problems with DB Write and Update

[Mike O]

Can you send a script snippet?
  ----- Original Message ----- 
  From: Denis Pointer 
  To: Ask-icd-ivr-support at external.cisco.com ; cisco-voip at puck.nether.net 
  Sent: Tuesday, August 18, 2009 8:07 PM
  Subject: [cisco-voip] Problems with DB Write and Update


  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



------------------------------------------------------------------------------


  _______________________________________________
  cisco-voip mailing list
  cisco-voip at puck.nether.net
  https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090818/f7548698/attachment.html>