I'm Toad for Oracle 22.214.171.124.
I'm having 1 Toad instance running, with 1 open connection only. Within the context of this single connection I'm working in three editor tabs as follows:
My current tab is the third one, labeled gen_templates_data_enriching.sql. I hit F5 to run the script, and I get the SP2-0552 error as shown above.
The confusing (and worrying) parts are
- the indicated bind variable does not exist in any of the three edit windows
- the sql text shown in the error panel (with my_package ... ) is form the second editor window, not the current one!
I'm not sure what has been going on, but it sure looks confusing to me...
Which script did Toad try to execute? Where does Toad get the unused bind variable name from? Neither of the two edit windows involved holds a reference to any stored script...
Why is Toad reporting the other window's sql text in the error message?
Can any of you make sense of this? I'll leave my Toad session open for the rest of the afternoon, so if you need any additional debug info, please let me know asap.
The issue might not reproduce at will, though it does within the context of this particular Toad session,