CREATE PROCEDURE product_insert_sp
(
IN p_internal_id varchar(255),
IN p_name varchar(255),
IN p_date_approved varchar(255),
IN p_prescription varchar(255),
IN p_production_class varchar(255),
IN p_strength varchar(255),
IN p_approval_number varchar(255),
IN p_authorization_procedure varchar(255),
IN p_classification_atc_code varchar(255),
IN p_classification_controlled_medicinal_product varchar(255),
IN p_classification_narcotics_class  varchar(255),
IN p_sales_stopped varchar(255),
IN p_interchange_strength_group_id varchar(255),
IN p_interchangeability_startdate varchar(255),
IN p_legal_name varchar(255),
IN p_pharmaceutical_form  varchar(255),
IN p_compref_quantity varchar(255),
IN p_pharmaceutical_product_id varchar(255))
BEGIN

		insert into medicine.product_data (
			internal_id,
            name,
            date_approved,
            prescription,
            production_class,
            strength,
            approval_number,
            authorization_procedure,
            classification_atc_code,
            classification_controlled_medicinal_product,
            classification_narcotics_class,
            sales_stopped,
            interchange_strength_group_id
			interchangeability_startdate,
            legal_name,
            pharmaceutical_form,
            compref_quantity,
            pharmaceutical_product_id

		)

	values
    (
		p_internal_id,
        p_name,
        p_date_approved,
        p_prescription,
        p_production_class,
        p_strength,
        p_approval_number,
        p_authorization_procedure,
        p_classification_atc_code,
        p_classification_controlled_medicinal_product,
        p_classification_narcotics_class,
        p_sales_stopped,
        p_interchange_strength_group_id,
        p_interchangeability_startdate,
        p_legal_name,
        p_pharmaceutical_form,
        p_compref_quantity,
        p_pharmaceutical_product_id
    );

END
;