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 -> ? Session killed - procedure works ?

? Session killed - procedure works ?

From: UniSoft <oracle_at_unisoft.dp.ua>
Date: 22 May 1998 12:06:56 +0300
Message-ID: <AC2OIPryqB@unisoft.dp.ua>


I'm trying to write a PL/Sql procedure. Some times (wrong loops, dbms_pipe owerflow, etc.) the procedure works indefinitely. I kill the session. But however I can't update the procedure - it's locked till db shutdown. Is there any way to stop procedure for update?
Sorry for such ehglish.

Thanks,

   Eugene
--


Eugene Brodskiy,                        e-mail: eugene_at_unisoft.dp.ua
UniSoft Ltd.,                                   unisoft_at_online.alkar.net
Lenina str,17, app.79                      tel: 38-0562-418487
Dnipropetrovsk,Ukraina                 tel/fax: 38-0562-458273

Received on Fri May 22 1998 - 04:06:56 CDT

Original text of this message

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