Set-up and Execution of Procedures

Tools & Utilities

Set-up and Execution of Procedures

I have written a procedure which uses temporary variables and also uses dynamic SQL as well.
I have not been able to compile or run the procedure.
Can anyone guide me on how to compile and run the procedure in detail?