All Forums Database
Karam 75 posts Joined 07/09
05 Jan 2012
Using store procedure in SQL. Is it possible ?

Haven't seen such a scenerio and would like to know if its pooisble to use store prcedure in a SQL statement?

Please share any insight !!

dnoeth 4628 posts Joined 11/04
06 Jan 2012

No, you can only CALL it.

Dieter

 

Dieter

Karam 75 posts Joined 07/09
06 Jan 2012

thanks Dieter...

is this facility available in any other DBMS ? 

SamGong 2 posts Joined 12/11
20 Jan 2012

You can call Store procedure as a block of program.

If you want call them in a SQL statement,  try Function, try SQL UDF.

 

http://forums.teradata.com/forum/extensibility/creating-sql-udf-issues

 

You must sign in to leave a comment.