Stored Procedure Dependencies

Database
Teradata Employee

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?

Tags (1)
2 REPLIES
Enthusiast

Re: Stored Procedure Dependencies

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

Enthusiast

Re: Stored Procedure Dependencies

I meant NOT PRESENT*