Question: DELIMITER / / CREATE PROCEDURE insert _ glaccount { IN account _ number INT, IN account _ description varchar ( 5 0 ) } BEGIN
DELIMITER
CREATE PROCEDURE insertglaccount
IN accountnumber INT,
IN accountdescription varchar
BEGIN
DECLARE duplicatecount INT;
SELECT COUNT INTO duplicatecount
FROM generalledgeraccounts
WHERE accountdescription accountdescription;
IF duplicatecount THEN
INSERT INTO generalledgersaccounts accountnumber, accountdescription
VALUES accountnumber, accountdescription;
SELECT FROM generalledgeraccounts WHERE accountnumber accountnumber;
ELSE
SELECT "DUPLICATE GENERAL LEDGER Description";
END IF;
END;
DELIMITER ;
CALL insertglaccount 'Accounting';
I am getting an error that insertglaccount does not exist
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
