Bind Variables with Oracle and DB2

[Anonymous]

I can not figure out how to use bind variables with this software. Is this supported? If so what is the syntax.

Thanks!

[Heiko Hilbert]

I'm not an Oracle expert. But SQLExplorer has a feature called Structured Comments. Open your Help/Help Contents menu and navigate to SQL Explorer / Structured Comments. The example there is: 

For example, to declare a cursor and execute a stored procedure which returns a result set in that cursor: 

• ${ parameter c output cursor } 
• ${ parameter my_date input date 'dd/MM/yyyy' } 21/11/2007 
• ${ parameter my_out output string } 
  begin 
      pkg_test.my_test_proc(:c, :my_date, :my_out); 
  end;