Archives of the TeradataForum

Message Posted: Thu, 18 Jan 2007 @ 11:34:53 GMT


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

Subj:		Re: Calling a procedure in a select statement

From:		Victor Sokovin

I would like to know whether it is possible to call a procedure in a select statement. My procedure takes three parameters and returns one parameter. My query in TD looks like this :

I don't think you can use procedures in this way. If you are looking for counterparts of Oracle functions then consider User Defined Functions (UDF). They can be used in SQL but to write them takes much more effort than in Oracle.

If the UDF threshold is too high you could think of making your SP write their results into certain tables and then join your existing tables to those "SP result tables". Perhaps this might work in some cases.

Regards,

Victor