Ken,

This is a bug in our driver and/or server engine. Please, use
java.sql.CallableStatement or "SELECT * FROM your_proc(...)" for now.

Best regards,
Roman Rokytskyy

--- In Firebird-Java@y..., "Roman Rokytskyy" <rrokytskyy@y...> wrote:
> Hi,
>
> Most likely this is a problem in our driver. Can you post your
script
> and Java code, so I can test it?
>
> Thanks!
> Roman Rokytskyy
>
> --- In Firebird-Java@y..., "Ken Richard" <kenr@a...> wrote:
> >
> > I am having a little trouble tracking down a problem and am
> starting to
> > wonder if there is an error in the driver. I am trying to
execute a
> > stored procedure using the "EXECUTE PROCEDURE" syntax with
> > Statement.execute(). The SQL statement works in ISQL - but fails
> when
> > using Statement.execute().
> >
> > I want to execute this way because I have a text file of SQL
> statements
> > to execute. The file includes meta-data updates that work fine.
> Each
> > statement from the file is committed before the next is started.
> >
> > The procedure in question has two input parameters and out output
> > parameter. I imagine the output parameter may be causing the
> problem.
> > I do not need to retain the output parameter in this case.
> >
> > The SQLException is:
> >
> > EXECUTE PROCEDURE procedure_name 'S1','S2'
> > ERROR [db.DbInitialize] Database Error
> > org.firebirdsql.jdbc.FBSQLException: GDS Exception. message
length
> error
> > (encountered 0, expected 8)
> > at
> > org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:480)
> >
> >
> > The internal GDS exception is:
> >
> > org.firebirdsql.gds.GDSException: message length error
(encountered
> 0,
> > expected 8) at
> > org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1456)
> > at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1374)
> > at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2
> (GDS_Impl.java:702)
> > at
> > org.firebirdsql.jca.FBManagedConnection.executeStatement
> (FBManagedConnec
> > tion.java:592)
> > at
> > rg.firebirdsql.jdbc.FBConnection.executeStatement
> (FBConnection.java:1045
> > )
> > at
> > org.firebirdsql.jdbc.FBStatement.internalExecute
> (FBStatement.java:916)
> > at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:471)
> >
> >
> > Any suguestions?