Reference Guide > TDV SQL Script > SQL Script Examples > Example 3 (User-Defined Type)
 
Example 3 (User-Defined Type)
This example declares a user-defined type named udt, and uses it in another user-defined type b.
PROCEDURE type_example1 ()
BEGIN
  DECLARE PUBLIC TYPE udt INTEGER;
  DECLARE TYPE b ROW (a INTEGER, b udt, c VARCHAR(255));
END