Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to force sql developer to prompt for user input for every execution ?

rogers7942Jul 10 2012 — edited Jul 13 2012
Hi Folks,

Environment: Oracle 11g (on Windows 7)
SQL Developer: *3.1.07*

I am executing a PL/SQL code off Sql Developer. The code uses substitution variables to prompt user for input. However,I am only prompted for the user input for the very first run of the code. For the subsequent executions, the code simply picks up the user input from the very first run. This behavior persists for all subsequent runs of the code.

I have executed the same piece of code from SQL*PLUS and the behavior seems normal (i.e. I am prompted for fresh input for every execution)

How can flush out the old user input so I can be prompted for new user input for every run of the code in sql developer?

Thanks in advance

rogers42
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 10 2012
1 comment
2,585 views