hello, I know how to use them in java.
What I need is to use the query as it is in a tool like toad or sql
tools, for debugging it.
Removeing variables and putting actual values is a bad way, I was
wondering if there is any way to do it.
On 25 Mag, 17:54, Ali Kemal DEMIRCI <demirci.alike...@gmail.com>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
