MySQL Forums
Forum List  »  Stored Procedures

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Approach to handle not all parameters getting passed in stored procedure
739
August 03, 2019 04:06AM


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.