Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can a View Execute a Stored Procedure?
- Thread starter ihda
- Start date
SantaMufasa
Technical User
Ihda,
Do you mean "Is it possible to execute a function within a view?"...I cannot envision a way to execute a stored procedure directly from any SQL statement.
Since a VIEW is simply a "named SELECT", let's begin by your posting a "wish-SELECT" that references a stored procedure in the way you wish you could reference the SP.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[ Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
Do you mean "Is it possible to execute a function within a view?"...I cannot envision a way to execute a stored procedure directly from any SQL statement.
Since a VIEW is simply a "named SELECT", let's begin by your posting a "wish-SELECT" that references a stored procedure in the way you wish you could reference the SP.
Mufasa(aka Dave of Sandy, Utah, USA)
[ Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.
- Status
Similar threads
- Question