Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Allow Stored Procedure that returns a result set to be accessed via SELECT statement
Tue, Jun 10 2014 6:18 AMPermanent Link

Adam Brett

Orixa Systems

If you have a Stored Procedure (i.e. "CurrentStocks", returning all data on stock-levels from a DB) it would be great to be able to write:

SELECT * FROM CurrentStocks

Of course EDB would have to check that the procedure returned a result set during the prepare.

I realise this raises security issues (Stored Procedure could include dangerous code), but I think it would be valuable.
Tue, Jun 10 2014 7:07 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam

>If you have a Stored Procedure (i.e. "CurrentStocks", returning all data on stock-levels from a DB) it would be great to be able to write:
>
>SELECT * FROM CurrentStocks
>
>Of course EDB would have to check that the procedure returned a result set during the prepare.
>
>I realise this raises security issues (Stored Procedure could include dangerous code), but I think it would be valuable.

Are you looking for a VIEW? The difference is that you can't pass parameters into a view.

Roy Lambert
Image