Home » SQL & PL/SQL » SQL & PL/SQL » can not insert into table
can not insert into table [message #224011] Mon, 12 March 2007 11:11 Go to next message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
Hi Everybody,
i have problem inserting records into table ,am working on Oracle9i Release 9.2.0.7.0 .
The error i get is :
ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
the problem is that the query i wrote did not select from any view at all??!
the whole query depend on tables ..so did i miss something or is this a BUG!!

Thanks in Advance,
bahaa
Re: can not insert into table [message #224017 is a reply to message #224011] Mon, 12 March 2007 11:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Maybe a trigger on your updated table?
Re: can not insert into table [message #224055 is a reply to message #224011] Mon, 12 March 2007 15:11 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
issue the following select

select object_type from user_objects where object_name='YOUR_TABLE_IN_CAPS';
Re: can not insert into table [message #224124 is a reply to message #224017] Tue, 13 March 2007 03:17 Go to previous message
bahy91
Messages: 91
Registered: September 2005
Location: Amsterdam
Member
Thank you very much ..you are right ..it was a trigger that cause all the trouble.

Thanks in Advance,
bahaa
Previous Topic: insted of trigger
Next Topic: Schema Query
Goto Forum:
  


Current Time: Thu Dec 08 16:14:37 CST 2016

Total time taken to generate the page: 0.15450 seconds