Topic
  • 1 reply
  • Latest Post - ‏2013-09-03T14:51:48Z by mohan4
mohan4
mohan4
2 Posts

Pinned topic Getting error while inserting columns in Oracle table

‏2013-09-03T06:28:30Z | array arrayindexoutofrange index insert of oracle out query range wef

Hi,

I was trying to insert a row into Oracle database consisting 20 columns in WEF.
I am getting "Array index out of range: 20" error message.

To my knowledge insert is working fine till 7 columns.

Is it a driver problem or do i need to install any fix pack??

Kindly assist me..

Attachments

Updated on 2013-09-03T15:14:16Z at 2013-09-03T15:14:16Z by mohan4
  • mohan4
    mohan4
    2 Posts

    Re: Getting error while inserting columns in Oracle table

    ‏2013-09-03T14:51:48Z  

    While trying to insert, if i hardcode all values, it is well and good, otherwise i'm getting "Array index out of range: Number of columns"

    I hardcoded 13 values out of 20, and entered values for the rest 7, and it is working fine.

    So my finding is when the number of dynamic inputs exceeds 7 the row is not getting inserted....


    The same query is working fine for DB2.
    I suspect that there may be a problem with connecting jar files. ( ojdbc6/ojdbc14  )..