Can I call a stored procedure from a view in mysql?

Question

No, you cannot. Views are typically read-only operations; and that behavior cannot be guaranteed if stored-procedures are invoked. 23 мая 2017 г.

Can a SQL view call a stored procedure?

Answers. No, but most-likely you can convert your stored procedure to a table-valued function. Then you can call the table-valued function in a view.

How do you call a procedure from a view in SQL?

How to call a stored procedure from a view in SQL Server1First, we will create a stored procedure in SQL Server Database.2Second, enable the Data Access on the SQL Server instance.3Third, create a view that uses the stored procedure.4In the end, we will call the view to get the final result.How to call a view in SQL Server

Can you execute a stored procedure in a view?

There could be scenarios where you want to use a Stored Procedure in view and Join the result set returned by a Stored procedure with some other tables/views. Step 2: Create Stored Procedure that will return all results.

Can you call a stored procedure from a UDF?

Yes we can call UDF in a SP but not the reverse. Details: If you know SP, we can write multiple queries in it. Calling a UDF is just like writing a Select query only.

Expert · Answer