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

Home -> Community -> Usenet -> c.d.o.server -> Q: "Autorollback" after raise_application_error()

Q: "Autorollback" after raise_application_error()

From: Gombos Bertalan <bgombos_at_freemail.c3.hu>
Date: Thu, 28 Oct 1999 16:48:37 +0200
Message-ID: <38186245.177461F2@freemail.c3.hu>


Hi all,

  When I call a stored procedure from OCI, Oracle generates a savepoint to begin of the procedure. If I issue a raise_application_error() and this error reaches the caller environment (Power Builder), Oracle gives a rollback to the former savepoint.
  Is it possible to prevent Oracle from rollbacking?

Bye:
--

    .---,                            G o m b o s  B e r t a l a n
    :   :
    :---'-. ,---. ,--. ,-.-.       rendszerfejleszto, Oracle mernok
    :     : :--   :      ;          mailto:bgombos_at_freemail.c3.hu
   ,' '---' '---' '      `-'

-- : ------------------------- Az elet megis egy habostorta? --- '10^2-1
Received on Thu Oct 28 1999 - 09:48:37 CDT

Original text of this message

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