MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Approach to handle not all parameters getting passed in stored procedure
Posted by: Todd Lane
Date: August 03, 2019 04:06AM

Hi,

I am running 5.7.12 and have a stored procedure that is basically mapped to a form.

Catch is that not necessarily every field in the form will have a response.

I read that all in parameters must have something passed to them to make the sp fire correctly.

How do you get around this? Some of the columns are int and some are varchar.

Thanks in advance

Todd

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Approach to handle not all parameters getting passed in stored procedure
828
Todd Lane
August 03, 2019 04:06AM
Re: Approach to handle not all parameters getting passed in stored procedure
410
Peter Brawley
August 03, 2019 11:16AM


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.