Question: DELIMITER / / CREATE PROCEDURE insert _ glaccount { IN account _ number INT, IN account _ description varchar ( 5 0 ) } BEGIN

DELIMITER //
CREATE PROCEDURE insert_glaccount
{
IN account_number INT,
IN account_description varchar(50)
}
BEGIN
DECLARE duplicate_count INT;
SELECT COUNT(*) INTO duplicate_count
FROM general_ledger_accounts
WHERE account_description = account_description;
IF duplicate_count =0 THEN
INSERT INTO general_ledgers_accounts (account_number, account_description)
VALUES (account_number, account_description);
SELECT * FROM general_ledger_accounts WHERE account_number = account_number;
ELSE
SELECT "DUPLICATE GENERAL LEDGER Description";
END IF;
END;
DELIMITER ;
CALL insert_glaccount(591, 'Accounting');
I am getting an error that insert_glaccount does not exist

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!