Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!a17g2000yqj.googlegroups.com!not-for-mail From: Frank Bergemann Newsgroups: comp.databases.oracle.server Subject: Re: throwing exception in parallel pipelined table function Date: Mon, 12 Dec 2011 02:56:19 -0800 (PST) Organization: http://groups.google.com Lines: 21 Message-ID: References: NNTP-Posting-Host: 193.0.246.21 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1323687379 6528 127.0.0.1 (12 Dec 2011 10:56:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 12 Dec 2011 10:56:19 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: a17g2000yqj.googlegroups.com; posting-host=193.0.246.21; posting-account=aqg0MQkAAADuyWnTjCjg6IuPmPHzaSAv User-Agent: G2/1.0 X-HTTP-Via: 1.1 padwebproxy1.pad.orga-systems.net (squid/3.1.9) X-Google-Web-Client: true X-Google-Header-Order: ASELCHRUVFNK X-HTTP-UserAgent: Mozilla/5.0 (Windows NT 5.1; rv:8.0.1) Gecko/20100101 Firefox/8.0.1,gzip(gfe) Xref: news.cambrium.nl On Dec 8, 6:42=A0pm, Frank Bergemann wrote: > what happens to such? > In my application it seems, it is catched by the main thread . > But i wonder how this can work if MULTIPLE parallel pipelined table > functions raise exception at different location of the code - e.g. for > user abort of main session(?!) > > - many thanks! > > regards, > Frank I found it out myself meanwhile In case of MULTIPLE parallel sessions started via pipelined table functions, there is given a dedicated exception to the main thread: ORA-12801: error signaled in parallel query server ... instead of the concrete exception(s) raised by the individual worker thread(s). regards, Frank