@chulett,,
Thanks removing the column for which i need to populate the value did the trick.. Now i am able to insert to the table successfully.
But i need to do a upsert instead of only insert statement.
When i give the update statement along with the insert statement separated by ';', it is throwing me a SIGBUS error. How to do a upsert in such a scenario.
Update will be done on the primary key of the column. The surrogate key which i am creating from the sequence will be present only in the Insert statement.
The query i am using is as below
Update schema.table set col2=?,col3=?,col4=?,col5=?,col6=?,col7=?,col=8,col9=? where col1=?;
insert into schema.table values (sequencename.nextval,?,?,?,?,?,?,?,?,?)
Basically, if i give only the insert , it is working properly but if i give the update also, then it is giving SIGBUS error