Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1322
  • Last Modified:

Not able to get the parameter windows displayed in TOAD 9.0(Quest software prod) for Oracle

Hello Everyone,

I am using TOAD @ my office and the database we have is ORACLE 10g.
I am recently not able to get the parameter window displayed.

For Eg: select * from emp
             deptno = :p_deptno
In this case a paramter window opens and asks for a value of "p_deptno".(so, this window is not showing up)

I was getting this earlier, but recently from a week or so, I am not able to get it displayed and, when I try to run it, it just displays every column as a null. (As if the table does'nt have any data, even though it has data).

Can you please help me out  in this matter. This Issue looks weird but it is making my life tougher as I deal with heavy coding.

Thanks,
 Vishal

0
vishal_singh
Asked:
vishal_singh
1 Solution
 
jwahlCommented:
make sure that the option "Prompt For Substitution Variables" is checked (right click in editor window).
Clipboard02.jpg
0
 
vishal_singhAuthor Commented:
Thanks for the solution
0
 
rodicasCommented:
Thank you, experts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now