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 -~----------~----~----~----~------~----~------~--~---