Using SQL Scanner to scan stored procedures, the following error is thrown after inspecting the SQL statement:
Invalid SQL statement
Must declare the variable variable_name.
Copy the scanned SQL statement to the tuning lab, where it will prompt for the variables during execution.
