Oracle Create Procedure

The Oracle Create Procedure Tool allows users to create stored procedures for a database. The following example is output for Oracle.


CREATE PROCEDURE TESTUSER.TEST_PROCEDURE (
	param1 IN CHAR(25),
	param2 IN OUT DATE,
	param3 OUT NUMBER
)
IS
--
-- Declare program variables as shown below
--	variable_name	data_type
BEGIN
	statements;
EXCEPTION
	WHEN exception_name THEN
		--statements;
END; --Procedure

Oracle Create Procedure