16.10 - Modifying Stored Procedures - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
klx1480972732157.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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;