15.10 - Example: Creating a Procedure with Parameters and Local Variables - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;