Archives of the TeradataForum

Message Posted: Mon, 17 Dec 2007 @ 18:55:13 GMT

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

Kamin,

I believe that Teradata Stored procedure can accomplish everything (Almost) that an Oracle SP could!

If you are good at writing lengthy SQL, you could probably replace almost all functionality that a Stored procedure has using a Macro. You could get results set using local bind variables using TD SP. You could also use cursors to process the entire result set.

I am unclear on what you are trying to accomplish.

If you could share the algorithm, one of us can better assist you.

Thanks,

Vinay Bagare

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