>
> That exception is a DSQL error...all of your procedures work on my

setup

> and don't return any exceptions. You're getting a result back,

right? So

> apparently the SPs are executing and then something is happening

afterwards

> that's causing this exception.
>
> So let's see the code: the exact SQL statement, your app code that

calls

> it and your app code that reads the result. Not a vague

description, but

> actual code.
>
> Helen

Sorry, I really can't follow you when you reduce all my info as being
vague.

I repeat myself:

SET TERM ^ ;
/* Connect using username: SYSDBA */
/* and server: WI-V6.3.0.4306 Firebird 1.5 */
SET SQL DIALECT 3^
SET AUTODDL ON^
CREATE DATABASE 'D:\TEST.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
DEFAULT CHARACTER SET UNICODE_FSS^

CREATE PROCEDURE SP_3
RETURNS (
ACCOUNTID INTEGER )
AS
BEGIN
ACCOUNTID = 1;
END^

COMMIT^

/* - - - - - - - - - - - - - - - -
List of possible problems detected
- - - - - - - - - - - - - - - - -
None
- - - - - - - - - - - - - - - - */

Connect with IB_SQL, check all monitor groups, run SP_3 in the DSQL
tab (EXECUTE PROCEDURE SP_3), and have a look at the monitor output.