Recompiling STORED PROCEDURE in Teradata

By ALTER, you can recompile the stored procedure.
The ALTER PROCEDURE feature enables recompilation of stored procedures without having to execute SHOW PROCEDURE and REPLACE PROCEDURE statements.

Syntax:
ALTER PROCEDURE procedure_name (parameters)
Executable statements;


Example:

If you want to execute in newer version for recompiling, then you can do with ALTER

ALTER PROCEDURE SP_Employee 
(IN name CHAR(20),
IN id INTEGER,
IN dept_no INTEGER,
OUT dname CHAR(10),
INOUT errstr VARCHAR(30))

BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '23505'
SET errstr = 'Duplicate Row.';

INSERT INTO Employee (EmpName, EmpNo, DeptNo )
VALUES (name, id, dept_no);

SELECT DeptName
INTO dname FROM Department
WHERE DeptNo = dept;
END;