Hi,

When I am trying to commit this stored procedure using IBO

create PROCEDURE cp_rec(kaynak_recid numeric (18, 0), hedef_rev numeric
(18,0))
RETURNS (sonuc_recid numeric (18, 0))
AS

BEGIN
sonuc_recid = gen_id(GN_REC, 1);

insert into rec
(ID, TANIM, ID_REV, MIKTAR_BAZ, ALTERNATIF_NO)
values
(:sonuc_recid,
(select tanim from rec where rec.id = :kaynak_recid),
:hedef_rev,
(select miktar_baz from rec where rec.id = :kaynak_recid),
(select ano from rec_alternatifno_bul hedev_rev));

SUSPEND;
END

I get error saying

ISC ERROR MESSAGE:
invalid request BLR at offset 218
BLR syntax error: expected Invalid BLR code at offset 218, encountered 255

And I do not know what this error means?...

Any ideas?

My system :

Win2000
FB 1.0

TIA

Çağatay Tengiz
System Development & MIS Manager
Etap Endüstri ve Yatırım Holding A.Ş.

c.tengiz@...

Tel : +90 232 479 10 66 / 139
Fax: +90 232 479 05 04


__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com