Why exception exporting query result on Derby ?

q="SELECT * FROM "+dbTable+" WHERE "+FieldName+" BETWEEN ? AND ? ORDER BY ID";
q="CALL SYSCS_UTIL.SYSCS_EXPORT_QUERY('"+q+"','"+OutFile+"', null, null, null)";
stm=cn.conn.prepareStatement(q);
stm.setString(1, sd.StringDataOraInizio);
stm.setString(2, sd.StringDataOraFine);
stm.executeUpdate();


I use Apache Derby but,
When i execute the attached code i receive an exception java.sql.SQLException: No input parameters.

The same query in other point of my program do not produce an exception.
Maybe i can't use system procedure with parameter ?
Thanks



.

Relevant Pages

  • C++ exception handling question
    ... tricky simulation work. ... during initialization for some choices of input parameters. ... code that throws and catches an exception? ... My code does not have the string 'Killed' in it anywhere, ...
    (Debian-User)
  • Table Looping Functoid ==> error btm1023: System.OutOfMemoryExcept
    ... I created a map using a Table Looping Functoid. ... error btm1023: Exception Caught: Exception of type ... While working with a few input parameters it worked fine, ...
    (microsoft.public.biztalk.general)
  • Re: Why exception exporting query result on Derby ?
    ... I use Apache Derby but, ... When i execute the attached code i receive an exception java.sql.SQLException: No input parameters. ...
    (comp.lang.java.databases)
  • Re: System.Security.SecurityException was unhandled
    ... The exception gave you the CLSID. ... the first thing to check might be whether the COM server ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • Re: collecting results in threading app
    ... but execute one at the time'. ... Could a Queue help me there? ... You can take a look at papyros, a small package I wrote for hiding ... # some exception was raised when executing this job ...
    (comp.lang.python)