Example: Creating a Procedure with Parameters and Local Variables - Teradata VantageCloud Lake

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

The parameter type for ip is not specified, and 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;