Hi,
Here is the sample of the creating the procedures & excuting the procedures.
Creating Procedure:
CREATE PROCEDURE appl_osmp.createTest(IN testName VARCHAR(20), IN ComponentIDs TEXT )
BEGIN
DECLARE TagID INT DEFAULT 1;
INSERT INTO TEST (name) VALUES (testName);
END
Droping procedure :
drop procedure createTest;
Call the procedure:
call createTest("tom5","16395,16722,17175,16999");
No comments:
Post a Comment