How do we call stored procedure dynamically?

suneesece

 Profile Answers by suneesece Questions by suneesece

• May 19th, 2010

We can call using dynamic SQL, Execute Immediate.

Answer Question  Select Best Answer

suneesece

 Profile Answers by suneesece Questions by suneesece

• May 19th, 2010

Select * from all_objects where object_type= 'PROCEDURE';

Shafik Ismail

 Profile Answers by Shafik Ismail Questions by Shafik Ismail

• Feb 27th, 2010

I am not too sure if I understand our question properly. If you wanted to find all the stored procedures defined to the database with a CREATE PROCEDURE command (let's say DB2), then run a query from ...

Answer Question  Select Best Answer