Archives of the TeradataForum
Message Posted: Mon, 09 Feb 2009 @ 15:32:47 GMT
| 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.