All Forums Database
ddmaddo 4 posts Joined 07/09
12 Nov 2015
Stored Procedure Dependencies

Is there a method, at compile time, to have the stored procedure resolve a volatile table that is not created within the stored procedure?

Danny Maddox

12 Nov 2015

Try to include "SQL SECURITY INVOKER" at the beginning of the SP. SQL Securty invoker will give a warning during compilation for any dynamic sqls that are present in db.
Something like this...
Replace Procedure SPName (Param1, Param2... Param n)
SQL SECURITY INVOKER
MAIN: Begin
Declare var1 datatype;
Declare var2 datatype;
... etc
End;
Hope it helps.
 
Thank you!
Ranga

12 Nov 2015

I meant NOT PRESENT*

You must sign in to leave a comment.