Insert into a view
677253May 17 2009 — edited May 17 2009Hello,
I have a simple view that display data inner joined from 2 tables.
I would like to insert data directly into the view, I'm would like to avoid creating 2 insert Statements.
Trying to insert directly into the view gives ORA-01779.
Is there a proven method of doing this?
Can I perhaps write some kind of stored procedure or something of that sort that would allow me to this (seemingly) simple insert ?
Thank you,
Maxim.