KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to call a user defined stored procedure from a select statement and its giving me an error. However when I call a system procedure it works just fine. Is there a way to call a user defined procedure from a select statement. This is for mysql SELECT ID, email FROM user PROCEDURE simpleproc(); give me an error ERROR 1106 (42000): Unknown procedure 'simpleproc' mysql> call simpleproc(); Query OK, 0 rows affected (0.21 sec) where as SELECT ID, email FROM user PROCEDURE ANALYSE(); works
Tags (comma-separated)
Save Edits
Cancel