16.10 - Modifying Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)

To modify a stored procedure definition, use the REPLACE PROCEDURE statement.

Example: Inserting Salary Information into the Employee Table

Assume you want to change the previous example to insert salary information to the Employee table for new employees.

The REPLACE PROCEDURE statement looks like this:

   REPLACE PROCEDURE NewProc (IN name CHAR(12),
                              IN number INTEGER,
                              IN dept INTEGER,
                              IN salary DECIMAL(10,2),
                              OUT dname CHAR(10))
   BEGIN
      INSERT INTO Employee (EmpName, EmpNo, DeptNo, Salary_Amount)
         VALUES (name, number, dept, salary);
      SELECT DeptName
         INTO dname FROM Department
            WHERE DeptNo = dept;
   END;