AW: Insert statement cause kernel to die

2004-12-29 Thread Zabach, Elke
crashes the kernel. Therefore no crash/correct behaviour if no > insert is to be done. And therefore my hope to receive more info and then > being able to see the problem. > > > >Thank you > > > >Elke > >SAP Labs berlin > > > > > > > >>-Urs

Re: AW: Insert statement cause kernel to die

2004-12-28 Thread Michael MacIntyre
case w_inventory is a view would be helpful. There is some check to be done for the record to be inserted and that check crashes the kernel. Therefore no crash/correct behaviour if no insert is to be done. And therefore my hope to receive more info and then being able to see the problem. Thank you

Insert statement cause kernel to die

2004-12-23 Thread Michael MacIntyre
Hi. I am trying to execute an Sql statement similar to this one: insert into w_inventory(inventory_id,contacts_id,product_id,unit_id,qty_in_stock,qty_in_stock_delivered) select seq_inventory.nextval,7597,68,1,1.0,0 from dual where not exists ( select 1 from w_inventory i where contacts_id=759