MySQL Forums
Forum List  »  Oracle

Triggers "instead of" for View with "joins"
Posted by: pak attack
Date: May 10, 2006 11:13AM

Sorry for the next message, but my problem was with Oracle -> MySQL and wasn't SQL server to MYSQL:

Hi! I'm trying to insert into view but this view is made of "join":

return the error:
"Cannot insert into join view 'v12.vista1' without fields list"

The solution for this problems is using trigger "INSTEAD OF" but in MySQL doesn't appear this type of TRIGGER.
What's the real solution ?
I forced to use views.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Triggers "instead of" for View with "joins"
7236
May 10, 2006 11:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.