Can we call another stored procedure and a trigger from

Question

Can we call another stored procedure and a trigger from

within a stored procedure in mysql? Asking because trying to migrate from oracle and they have something like packages which is not available in mysql.

#english #programming #sql

0

07.02.2022

6 ответов

11 просмотров

Ilya Zviagin

Stored procedure languages are all different in different DBMS, so it is strange that you even have dared to start this

0

07.02.2022

Deb😎 Автор вопроса

Ilya Zviagin
Yes, you can. Triggers cannot be called explicitly...

Ok

0

07.02.2022

Deb😎 Автор вопроса

Ilya Zviagin
Stored procedure languages are all different in di...

Yeah but I will have to eventually as we have decided to move from oracle to open source

0

07.02.2022

Ilya Zviagin

Deb😎
Ok

Although formally mySQL implements all features of stored languages, the ideology and architecture of Oracle and mySQL are very different in respect to stored code execution. You will have to re-write all code of stored procedures completely and for suite parts of your app even the app itself. My prophecy is that you will not do this transfer or spend very much efforts to it.

0

07.02.2022

Ilya Zviagin

Deb😎
Yeah but I will have to eventually as we have deci...

Wish you much luck

0

07.02.2022

Ilya Zviagin · Accepted Answer

Ilya Zviagin

Yes, you can. Triggers cannot be called explicitly, they are get called automatically by the DBMS when a triggering event happens

0

07.02.2022

169 похожих чатов

Can we call another stored procedure and a trigger from

6 ответов

Похожие вопросы