Forms Bug ?
From: Josef Huber <josef.huber_at_ennstal.at>
Date: Tue, 1 Jun 1999 21:41:55 +0200
Message-ID: <375439c8.0_at_news.profinet.at>
Forms Version 6.0, Oracle 8i
Date: Tue, 1 Jun 1999 21:41:55 +0200
Message-ID: <375439c8.0_at_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 - 21:41:55 CEST