I have upgraded web application from Interbase (open source 6 with
interclient) to the latest Firebird and FirebirdSQL driver..

I'm encountering some code that no longer works..

String _sSql = "{call sp_do_due_date}"
CallableStatement _stmt = this.g_con.prepareCall(arg_sSql);
_stmt.executeQuery();

The stored procedure has NO inputs or outputs..

It fails with an error (see below)

I searched the newsgroups but could find no example of a stored
procedure with no inputs. (All of my stored procedures that have
inputs work fine.. ??)

Suggestions..??

John...


=============== stack trace of error ================

GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 19
null

at
org.firebirdsql.jdbc.AbstractCallableStatement.executeQuery(AbstractCallableStatement.java:198)
at
com.microps.dao.impl.InterbaseWebSalesDAO.callStoredProc(InterbaseWebSalesDAO.java:323)