Re: Forms Bug ?

From: Margot <margot.levasier_at_tip.nl>
Date: Fri, 04 Jun 1999 06:17:10 GMT
Message-ID: <37576b4b.1041469@news.tip.nl>

A few years ago I had a simular problem with Oracle 7. Perhaps Oracle 8i has the same 'problem':

I discovered that you can 'permit or prohibit procedures and stored functions from issuing COMMIT and ROLLBACK statements' ( Oracle7 Server SQL Reference) with the ALTER SESSION command:

ALTER SESSION ENABLE COMMIT IN PROCEDURE; or
ALTER SESSION DISABLE COMMIT IN PROCEDURE; On Tue, 1 Jun 1999 21:41:55 +0200, "Josef Huber" <josef.huber_at_ennstal.at> wrote:

>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 Fri Jun 04 1999 - 01:17:10 CDT