17.10 - Example: Creating a Procedure with Parameters and Local Variables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

The following example creates a valid SQL procedure named sp_sample1 with the following parameters and local variables:

Variable Type Variable Name
IN ip
OUT op
local variable var1

Because the parameter type for ip is not specified, it defaults to IN. This procedure does not contain any condition handlers.

    CREATE PROCEDURE sp_sample1(   ip INTEGER, 
                               OUT op INTEGER) 
    BEGIN DECLARE var1 INTEGER;
      SELECT col1 INTO var1 
         FROM tab1 
         WHERE col2 = ip;
      SET op = var1 * 10;
    END;