I would like to how to automate the UNIT test for plsql code. My requirement is developer should simply develop the code. If they want to do the testing, he may has to run the tool. (open source/licensed). Please suggest some tool or methodologies to develop the tool.
For example:
1. If the developer is developing this procedure.
CREATE OR REPLACE PROCEDURE VK_EMP_PROC(P_empId IN NUMBER, P_EMP_NAME OUT VARCHAR2)
AS
BEGIN
SELECT EMPNAME INTO P_EMP_NAME FROM EMP WHERE EMPID=P_EMPID;
EXCEPTION WHEN OTHERS THEN
NULL;
END;
2. He may do the UNIT Testing on the following scenarios:
INPUT NULL OUTPUT NULL
INPUT 10 OUTPUT HI
INPUT 100 OUTPUT NULL
3. These test cases are required to automate. Any suggestions.