🚀 go-pugleaf

I am trying to do a paremeterised query

select column1 from table where column2 = :param

I have used the Datmodule to handle the queries and set the paramneter
variables etc
and code of the form

  ParameterRow pr = new ParameterRow();
  Column prcol = new Column();
...
...
    column1.setColumnName("PARAM");
    column1.setDataType(borland.jbcl.util.Variant.BIGDECIMAL);

querySecurity.setMetaDataUpdate(borland.jbcl.dataset.MetaDataUpdate.NONE);

    querySecurity.setColumns(new Column[] {column1});
  prcol.setColumnName("PARAM");
  prcol.setDataType(borland.jbcl.util.Variant.BIGDECIMAL);
  pr.addColumn(prcol);
  pr.setBigDecimal("PARAM", bigdecimalvariable);

In the Datamodule class when I do a test Query I get a failure with the
message

'ORA-1008 not all variables bound'

Can someone confirm whether this is an oracle JDBC driver problem ( I am
using the beta type 4  driver)?
Or is there something more fundamental that I have missed out?

Thanks.
--
Regards ...
-----------------------------------------------------------------
Raman Mistry <raman@ubiquity.co.uk>

Ubiquity Software Corporation Limited
Imperial House, Imperial Way
Celtic Lakes,
Newport NP1 9UH

http://www.ubiquity.co.uk
Tel : +44 (0)1633 811806
Fax : +44 (0)1633 811807