Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016