CREATING ORACLE PROCEDURE USING JAVA JDBC

Today tried writing a quick jdbc program to create an Oracle stored procedure dynamically. It was so bizarre, that jdbc creates procedure but status is invalid. So finally found reason. Typically stored procedures end with '/' (don't know why - may be signal to Oracle about end of program). Once removed it then it started working OK.

Here is sample JDBC & stored procedure:

CREATE OR REPLACE PROCEDURE TEST1 (CNT IN NUMBER)
AS FIRSTNUM NUMBER DEFAULT 0;
BEGIN
FIRSTNUM := 1;
DELETE FROM SCOTT.TEST; COMMIT;
FOR I IN 1 .. CNT LOOP
FIRSTNUM := FIRSTNUM + 1;
INSERT INTO SCOTT.TEST VALUES(FIRSTNUM,'XXXX');
COMMIT;
END LOOP;
END TEST1;