Hi All,

Whta's wrong with:

CREATE PROCEDURE ADMINISTRATOR.typeProc(out retVal myType)
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
BEGIN
declare myObj myType;
set myObj.ame = 'deepak';
set myObj.age = 10;
set retVal = myObj;
END@

where myType is declared as:
create type myType (nam varchar(20), age int) mode db2sql.
The error I get is:
The data type for parameter or variable "retVal" is not supported in the SQL routine.
Same is the case with myObj if I remove the out parameter.


Regards,
Deepak Ajmera

Deepak,
According to the SQL Reference manual, User Defined Datatypes are not supported for parameters.

Andy

Thank You

Regards,
Deepak Ajmera