Hello Alberto,
try {
PreparedStatement ps = con.prepareStatement("Select * from table
where column1 = ?");
ps.setString(1, "12");
ResultSet rs = ps.executeQuery();
} catch (Exception e) {
// TODO: handle exception
}
On Mon, May 25, 2009 at 4:14 PM, Alberto <alberto.rol...@gmail.com> wrote:
>
> 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
>
> >
>
--
Saygılarımla,
Ali Kemal DEMİRCİ
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
