ORA-01008: not all variables bound ... in pl/sql developer 10.0.2.1697

[Jeevan]

Hi,
I am using pl sql developer 10.0.2.1697.

and in sql window, I have a query which uses placeholders

select t.*, t.rowid from minf t
where t.p_mid = :MID;

How to use such queries in pl sql developer?

My colleagues are suggesting - switch Oracle SQL Developer, which prompts user for value to use for the placeholders.

which does not appeal to me (PL/SQL developer is THE tool for sql development).

thanks
Jeevan

 

[Roeland]

Use a test window.

You could change your SQL window to a Test window with a right mouse click.

Tip: press the gray arrow in the black circle pointing down to fill in the variables

 

[Jeevan]

Thanks Roeland,

BTW, found another way,

In a SQL Window, itself, edit the query and use '&' instead of ':'

select t.*, t.rowid from minf t
where t.p_mid = ∣

When the SQL is executed (F8 or Ctrl+F8) a window pops up, asking for values for place holder.

thanks
Jeevan

 

[Roeland]

Then you are using substitution variables, and not bind variables. That's fine by me, but now you know it...