insert_new_COA

Parameters

Name	Type
table_name	VARCHAR(50)
ind	INT
supaccount	VARCHAR(50)
level	INT
code_of_account	VARCHAR(50)
account_description	VARCHAR(50)
total_cost	INT
review_status	VARCHAR(50)
prn	VARCHAR(50)

SQL Definition

CREATE PROCEDURE `insert_new_COA`(IN table_name VARCHAR(50), IN ind INT, IN supaccount VARCHAR(50), IN level INT, IN code_of_account VARCHAR(50), IN account_description VARCHAR(50), IN total_cost INT, IN review_status VARCHAR(50), IN prn VARCHAR(50))
BEGIN
    SET @stmt = CONCAT('INSERT INTO ', table_name,
    						' (ind, supaccount, level, code_of_account, account_description, 
    							total_cost, review_status, prn) 
    							VALUES (?, ?, ?, ?, ?, ?, ?, ?)');
    PREPARE stmt FROM @stmt;
    SET @ind = ind;
    SET @supaccount = supaccount;
    SET @level = level;
    SET @code_of_account = code_of_account;
    SET @account_description = account_description;
    SET @total_cost = total_cost;
    SET @review_status = review_status;
    SET @prn = prn;


    EXECUTE stmt USING @ind, @supaccount, @level, @code_of_account, @account_description,
    @total_cost, @review_status, @prn;
    DEALLOCATE PREPARE stmt;
END;;