Facing issues while creating User Defined Function

Database

Facing issues while creating User Defined Function

Hi All,

I am getting below error while creating below UDF in Teradata 15.0

CREATE FUNCTION xml_extract( xml_text LOCATOR CLOB)

     RETURNS TABLE (cust_id INTEGER,

                    store   INTEGER,

                    item    INTEGER)

     LANGUAGE C

     NO SQL

     EXTERNAL;

 

Error: CREATE FUNCTION Failed Error:3706 Syntax Error:Data type xml_text doesn't match a Defined Type Name.

 

Can anyone please tell me what am I doing wrong here??

 

Thanks

Sud

1 REPLY
Teradata Employee

Re: Facing issues while creating User Defined Function

Syntax is CLOB AS LOCATOR