Try &var.

2009/5/25 Alberto <alberto.rol...@gmail.com>

>
> hello, maybe this is a stupid question, but I'm not able to find the
> answer.
>
> I have a query, that is ran via JDBC, It contains bind variable.
>
> for example
>
> Select * from table where column1 = :var
>
> With jdbc,I assign variable value and everything is fine.
>
> I would like to test the query (of course, a more complex one) with
> Sql Tools (similar to Toad, but free).
>
> Of course, If I try to run the query as it is, I get a
>
> ORA-01008: not all variables bound
>
> the questio is: how do I assign variables values for testing the
> query ?
>
> Thank you!
> Alberto
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to