Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2009 @ 10:03:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I am converting an Oracle Store Procedure to Teradata Stored Procedure.

Here Var_Contract_Lines is a variable which contains long text and we need to break it up.

Below statements is used for break up.

     TYPE Table_Type IS TABLE OF VARCHAR2(10000);

     Var_Table_Type Table_Type := Table_Type();

     LOOP

     Var_Row_Lvl_Cntr := Instr(Var_Contract_Lines, '@');

     EXIT WHEN(Nvl(Var_Row_Lvl_Cntr, 0) = 0);

     Var_Table_Type.EXTEND;

     Var_Table_Type(Var_Table_Type.COUNT) := Substr(Var_Contract_Lines, 1,
     (Var_Row_Lvl_Cntr - 1));

     Var_Contract_Lines := Substr(Var_Contract_Lines, Var_Row_Lvl_Cntr + 1);

     END LOOP;

I need equivalent to above statements in Teradata.

And in Oracle they have define IN parameter as LONG but when I declare as LONG Varchar in Teradata for the same IN parameter I get an error

5499: The data size for input parameters exceeds the maximum allowable row length.

How to resolve this error?

Regards,

Ragavendran

	<Prev	Next>		<<First	<Prev	Next>	Last>>