MySQL Forums
Forum List  »  Oracle

Oracle trigger Migration issue. trigger in one Schema referring table of another schema
Posted by: Aditya Gaikwad
Date: November 25, 2010 08:07AM

Hi,
We are migrating Oracle Database to MySQL.
Oracle database has several schemas. We have migrated all the schemas(tables, views) from Oracle to MySQL.
While migrating triggers we are facing following issue.
lets say we have two schemas Schema1 and Schema2.
Schema1 has a trigger which refers table of Schema2. This is causing problem. The scenario is discussed below:

create trigger Schema1.tableA
after delete on Schema2.tableB
begin
-- do something, sql statements;
end;

The error is happening at Schema2.tableB and below is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

Does anyone have concrete idea about whether this can be done in MySQL or not? & if it is possible to do this, what is the correct way to do it.

Any help on this would be highly appreciated

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle trigger Migration issue. trigger in one Schema referring table of another schema
3521
November 25, 2010 08:07AM


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.