Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PLSQL code and different ORACLE versions

Re: PLSQL code and different ORACLE versions

From: Kay Kanekowski <kkanekowski_at_mindcommerce.de>
Date: Fri, 13 Jul 2001 10:24:57 +0200
Message-ID: <9imbi0$isc$1@fermi.tro.net>

Hi ,

what's about

 define v817 = '--'
 define v805 = ''

...

&v817 FORALL ...
&v805 FOR ... LOOP
...

We worked this way to switch the
...

   &ex_pragma PRAGMA AUTONOMOUS_TRANSACTION;
...

off for testing in PersonalOracle 7 instead of Oracle 8.1.7 on production.

You only switch the variable and run the script. Ok

hth
Kay

Mail: kkanekowski_at_mindcommerce.de Received on Fri Jul 13 2001 - 03:24:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US