Re: WHY the store procedures
The main usefulnesses of stored procs or funcs are to encapsulate & parameterise a query, or the job requires flow control logic of the sort that MySQL supports only in stored routines.
A commonly fatal drawback of MySQL stored procs & funcs is that the MySQL system of regulating privileges for them does not sit well in shared hosting environments; indeed for this reason many shared hosting providers don't support MySQL stored procs & funcs at all.
Subject
Views
Written By
Posted
2519
February 23, 2015 04:05AM
Re: WHY the store procedures
1078
February 23, 2015 11:15AM
883
February 25, 2015 01:38AM
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.