 |
 |
Archives of the TeradataForum
Message Posted: Wed, 11 Feb 2009 @ 09:16:33 GMT
| 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
| |
