Toad asks for the value of a parameter even if it is not necessary when doing control + enter.
To reproduce the problem follow the steps below:
1)Paste the following code into the Editor:
BEGIN
SELECT t.dummy
FROM (SELECT dummy FROM DUAL) t;
END;
2)Select just the select and click control + Enter , toad opens a pop up (that is ok so far).
3) If you click on ok then toad asks you the value for :t_0.
That should not be necessary as you have all the info inside the select.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center