|
Archives of the TeradataForumMessage Posted: Wed, 04 Feb 2009 @ 10:03:08 GMT
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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||