Xref: alice comp.databases.oracle.server:65146 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!news.algonet.se!algonet!uninett.no!newsfeed1.telia.no!news.telia.no!not-for-mail From: "Pål Jakobsen" Newsgroups: comp.databases.oracle.server References: <37D7A1B0.F5A04139@Unforgettable.com> Subject: Re: Stopping an PL/SQL procedure Lines: 44 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Message-ID: Date: Thu, 09 Sep 1999 17:11:42 GMT X-Complaints-To: abuse@telia.no X-Trace: news.telia.no 936897102 195.204.232.226 (Thu, 09 Sep 1999 19:11:42 CEST) NNTP-Posting-Date: Thu, 09 Sep 1999 19:11:42 CEST Organization: Telia Internet Public Access Thank you for answering - I am sorry I forgot to tell. The PL/SQL procedure is named "termin" and exists in a package "terminprocedure". I execute it from the prompt in sqlplus with the command execute terminprocedure.termin; - then it seems to go into an endless loop somewhere. I need to force it to stop without shutting the database down. Thank you. Kenneth C Stahl wrote in message <37D7A1B0.F5A04139@Unforgettable.com>... >"Pål Jakobsen" wrote: > >> I am debugging an PL/SQL procedure which sometimes goes wild. How can I stop >> this. I have tried to stop the session in the instance manager but this >> don´t help. Is there any command to use to stop the procedure from running >> immidiately. >> >> Thanks > >You need to supply more information than this. I use pl/sql all the time and I >can always stop it when needed, but then I'm working under a specific set of >circumstances. > >What you have not told us is how you are running the pl/sql. Are you running it >as a script from within sqlplus? Are you executing a stored procedure from >within sqlplus? Are you running a pl/sql block from a Pro-C program running on >the host? Are you running a pl/sql block from a Pro-C program running on a >client? Are you running a pl/sql block from an OCI program? Are you running a >pl/sql block from a client application such as Visual Basic or Visual C++? This >type of information is absolutely required in order to identify what methods can >be used to stop the pl/sql from running once started. > >