Default values to input parameters
DROP PROCEDURE IF EXISTS nb_seller_info_update//
CREATE PROCEDURE nb_seller_info_update
(
IN nb_seller_name_gb CHAR,
IN nb_seller_address_1_gb CHAR,
IN nb_seller_address_2_gb CHAR,
IN nb_seller_city_gb CHAR,
IN nb_seller_state_gb CHAR,
IN nb_seller_zip_gb CHAR,
OUT nb_seller_sequence_gb INT,
OUT nb_result INT
)
BEGIN
DECLARE nb_result_tmp INT DEFAULT 1;
DECLARE MY_ERROR CONDITION FOR SQLSTATE '23000';
DECLARE CONTINUE HANDLER FOR MY_ERROR SET nb_result_tmp = 0;
IF EXISTS ( SELECT nb_seller_code FROM nb_seller_master WHERE nb_seller_name = nb_seller_name_gb) THEN
SELECT nb_seller_code INTO nb_seller_sequence_gb FROM nb_seller_master WHERE nb_seller_name = nb_seller_name_gb;
ELSE
INSERT INTO nb_seller_master(
nb_seller_name,
nb_seller_addrress_1,
nb_seller_addrress_2,
nb_seller_city,
nb_seller_state,
nb_seller_zip
)
VALUES(
nb_seller_name_gb,
nb_seller_address_1_gb,
nb_seller_address_2_gb,
nb_seller_city_gb,
nb_seller_state_gb,
nb_seller_zip_gb
);
SELECT nb_seller_code INTO nb_seller_sequence_gb FROM nb_seller_master WHERE nb_seller_name = nb_seller_name_gb;
END IF;
SET nb_result = nb_result_tmp;
END;
//
Is there neway i can assign default values to input parameters without modifying the code too much.