Re: Able to add only one entry to database
If a stored routine param has the same name as a referenced column, how is MySQL supposed to know which refers to which?
For params, adopt a naming standard that prevents this from happening, eg orefixing each param with 'p_'.
But why are you using an sproc to do Inserts and Updates!?
Subject
Written By
Posted
Re: Able to add only one entry to database
June 24, 2016 09:02AM
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.