Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 09:25:33 GMT

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

Rakesh:

You are not giving us much to go on regarding your problem, if there is one. Neither are you telling us what you are using to call the SP.

So, I will state my assumptions:

1. the SP is created

2. you have issued a CALL to the SP

3. it is aborting with an overflow or other such error

4. you are calling the SP using SQL-A

When calling an SP from SQL-A, there is no mechanism for defining shared memory other than providing data values going in and reserving an area to receive it back. To CALL your SP, you should be using this command:

     CALL usp_NEXTDATE(date_final);

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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