Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2009 @ 15:32:47 GMT

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

Subj:   Re: Teradata Equivalent for Collection Data Type in Oracle
From:   Geoffrey Rommel

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.

  <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: 15 Jun 2023