I have copied a SELECT statement from a stored procedure into the Optimize SQL window. I now want to set the values for the parameters (bind variables in Oracle lingo). I can’t find the tab that is described in the Help. Of course, no screen image is included in the help. Another area of the help says to just click on the auto optimize icon, implying that it will then prompt for the values, but that doesn’t happen. The status goes to “Checking bind variables” and after an hour, it is still in the same status.
How can I enter values for the parameters needed by my SELECT statement?