Example 5 (Pipe Variable)

This example inserts the categories from the Northwind database into a PIPE variable.

PROCEDURE pipe_example2 (OUT param1 PIPE (col1 CHAR), IN param2 INT)

BEGIN

  FOR x AS SELECT Categories.CategoryName, Categories.CategoryId

           FROM /shared/access/Categories Categories

  DO

    IF x.CategoryId = param2 THEN

      INSERT INTO param1 (col1) VALUES (x.categoryName);

    END IF;

  END FOR;

  CLOSE param1;

END