Using store procedure in SQL. Is it possible ?

Database
Enthusiast

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 !!

3 REPLIES
Junior Contributor

Re: Using store procedure in SQL. Is it possible ?

No, you can only CALL it.

Dieter

Enthusiast

Re: Using store procedure in SQL. Is it possible ?

thanks Dieter...

is this facility available in any other DBMS ? 

Teradata Employee

Re: Using store procedure in SQL. Is it possible ?

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