At 10:06 PM 04-02-02 +0100, you wrote:

>Hi,
>
>I got something like this:
>
>ISC ERROR CODE 335544569
>ISC ERROR MESSAGE
>Dynamic SQL Error
>SQL error code = -804
>SQLDA missing or incorect version, or incorect number/type of variables

This seems like that old InterBase DSQL bug (fixed in Firebird RC1) that can arise when re-executing a prepared stored procedure ("the infamous XSQLDA bug"). It occurs because certain variables in the API interface related to input parameters are not properly re-set after the first execution and are not handled properly by DSQL in subsequent executions. I don't know if this fits your conditions though...What database version are you using?

Workarounds suggested to have been effective include:
1. have the client app to unprepare and re-prepare the stored procedure each time it executes.
2. add a dummy RETURNS parameter and a SUSPEND statement and call the procedure with SELECT instead of EXECUTE.

>and
>
>ISC ERROR CODE 335544333
>ISC ERROR MESSAGE
>Internal gds software consistency check (can't continue after bugcheck)
>
>This error sometimes appeard sometimes not. This is during calling database
>procedure.

It might or might not be related to the first problem - I've never heard of a correlation....but there is a first time for everything... It indicates database corruption "of some sort". Get hold of this paper http://www.ibphoenix.com/ibp_db_corr.html for a procedure to attempt to fix (or isolate and remove) corrupt structures. Keep a record of problems found in case you need to get back to us with further information about the problem.

regards,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________