Forms Bug ?

From: Josef Huber <josef.huber_at_ennstal.at>
Date: Tue, 1 Jun 1999 21:41:55 +0200
Message-ID: <375439c8.0@news.profinet.at>

Forms Version 6.0, Oracle 8i

The value of eht in the db is 'ABCD'

Procedure in Forms
PROCEDURE test IS
l_eht artikel.eht%TYPE;
BEGIN
l_eht := nvl(' ','1234'); -- l_eht = ' ' it's ok

update artikel set eht = nvl(l_eht,eht)

where katalog_id = 8 and artikel_nr = 'TEST'; commit;
END;
Know i Select eht from artikel ... and the value is 'ABCD'

When i run the above procedure as stored procedure the result is ' ' !!

Any suggestion ? Received on Tue Jun 01 1999 - 14:41:55 CDT