Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Teradata Equivalent for Collection Data Type in Oracle
From:   Ragavendran Srinivasanmanikandan


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();


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

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


     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?



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023