Re: Trigger exception problem

Oops:)

I didn't remember exact parameter to use when calling 'userenv()'.

So I just tried:

    select userenv('SESSIONID') from ( select * from dual ) ; and then pasted it (as it was) into e-mail message.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, December 07, 2001 1:43 PM

> If you're gonna do that, then why not:
>
> select decode(process, process, process)
> from ( select * from ( select * from v$session ) )
> where decode(audsid, audsid, audsid) =
> ( select userenv('SESSIONID') from ( select * from dual ) );
>
> Seriously though, why not just use
>
> select * from v$session where AUDSID = userenv('SESSIONID')
>
> :-)
>
> -p
> ---
> www.pythian.com -- vallee_at_pythian.com -- 877-PYTHIAN
> Smarter than adding another team member, Pythian has new services for
> supplementing DBAs: get our help with monitoring, 24x7 on-call, daily
> verifications, storage management, performance and more.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, December 07, 2001 1:23 PM
>
>
> If you need current process:
>
> select process from v$session where AUDSID = (select userenv('SESSIONID')
> from dual);
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Friday, December 07, 2001 12:35 PM
>
>
> > I told you I knew it was something stupid. Thanks the process was it.
I
> got rid of the process code and the duplicate error does now populate the
> exception table like I wanted!
> >
> > I know need to figure out how to capture the specific process. Probably
> next week when hopefully my head cold is gone, my kid isn't teething and I
> have had some sleep.
> >
> > Thanks to all and to all a good weekend!
> >
> > Kathy
> >
> > -----Original Message-----
> > Sent: Friday, December 07, 2001 5:35 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Kathy,
> >
> > I beleive the problem is in the exception handler:
> > select process into v_process from v$session...This is returning
multiple
> rows.
> >
> > Rick
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: JRicard982_at_aol.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > Confidential
> > This e-mail and any files transmitted with it are the property
> > of Belkin Components and/or its affiliates, are confidential,
> > and are intended solely for the use of the individual or
> > entity to whom this e-mail is addressed. If you are not one
> > of the named recipients or otherwise have reason to believe
> > that you have received this e-mail in error, please notify the
> > sender and delete this message immediately from your computer.
> > Any other use, retention, dissemination, forwarding, printing
> > or copying of this e-mail is strictly prohibited.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kathy Duret
> > INET: KathyD_at_belkin.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Vallee
> INET: dbalist_at_pythian.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).