RE: Stored Procedure
Hey Todd,
thanks, but I already tried the hardcoding path and the same error
happened.
Christian
>----------
>Von: Todd Bernhardt[SMTP:TBernhardt@wii.com]
>Gesendet: Dienstag, 30. Juni 1998 01:26
>An: Hofinger, Christian; 'informix-list@iiug.org'
>Betreff: RE: Stored Procedure
>
>Christian,
>
>Your error 687 *may* be solved by hardcoding a path (ie. =
/tmp/trace.out)
>to a known directory. I spent an embarrassing number of hours recently
>trying to track down this problem. With my wonderful sense of humor, I
>appreciated the catch-22 I was in--it was a good one, however my
>wonderful sense of humor did become stressed as the hours wore on!
>
>Good luck!
>
>-Todd
>
>> ----------
>> From: Hofinger,
>> Christian[SMTP:Christian.Hofinger@dresdner-bauspar.com]
>> Sent: Monday, June 29, 1998 6:08 AM
>> To: 'informix-list@iiug.org'
>> Subject: Stored Procedure
>>=20
>> Hallo
>>=20
>>=20
>> this is my stored procedure.
>>=20
>> -------------------------------------------------------
>>=20
>> create procedure pr_update_import()>>=20
>> define i,j INT;
>>=20
>> TRACE OFF;
>> SET DEBUG FILE TO 'trace.out';
>> TRACE ON;
>>=20
>> let j =3D 1;
>> foreach cur1 for select testschalter into i from import
>> if i > 100 and i < 1000 then
>> begin work;
>> update import set testschalter =3D j where current of cur1;>> commit work;
>> let j =3D j + 1;
>> end if
>> end foreach
>>=20
>> trace off;
>>=20
>> end procedure
>>=20
>> ----------------------------------------------------------
>>=20
>> Two errors : 687 : Set debug file before tracing
>>=20
>> If I leave the tracing :
>>=20
>> 255 : not in transaction=20
>>=20
>> I have no answer !!
>>=20
>> Thanks in advance
>>=20
>>=20
>> In der Hoffnung das Deutschland Weltmeister wird verbleibe ich,
>>=20
>> mit freundlichem Gru=DF
>>=20
>> Christian Hofinger
>> ------------------------------------------------
>> Anwendungsentwickler Dresdner Bauspar AG
>> Tel. : 069 263 - 7830
>> EMail : Christian.Hofinger@dresdner-bauspar.com
>>=20
>