I observe an Integer Overflow Exception after 32769 calls to the
same stored procedure with IBObjects.
Is this replicatable on other systems as well?
Is this somehow transaction related?

Here's the test StoredProc:
SET TERM ^ ;
CREATE PROCEDURE "test1"
RETURNS (
"refno" INTEGER)
AS
begin
/* Procedure Text */
"refno" = 1;
suspend;
end
^
SET TERM ; ^
GRANT EXECUTE ON PROCEDURE "test1" TO SYSDBA;

and this is the test procedure, which raises the exception ...
procedure TTEST4.Button1Click(Sender: TObject);
VAR I: integer;
ref:integer;
begin
allocconsole;
I:=0;
repeat
INC(I);
Write(I,' ');
IB_StoredProc1.Execute;
until i=100000;
end;

My configuration: Delphi7 Prof, Firebird 1.5, IBO V4.5.Ai

Thanks
Gunther





___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de