Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2009 @ 09:16:33 GMT


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


Subj:   Re: Teradata Equivalent for Collection Data Type in Oracle
 
From:   Galazka Krzysztof Marek

Geoffrey Rommel wrote:

  First, as has been pointed out before in this forum, you should beware of simply "converting" Oracle procedures to Teradata procedures. Oracle procedures can often be changed to set-based SQL.  


  All that aside, however, error 5499 is occurring because stored procedures have a limit on the total length of the input parameters (64KB, probably). LONG VARCHAR is probably too long.  


  The rest of your questions can be answered by looking up the syntax in the Stored Procedures manual.  


Geoffrey,

Is it your way of saying there's no simple way ?
:-(


Thanks for your hints !

Krzysztof



     
  <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