Don't worry about it... I was just happy for the solution! Save me time and achoo...
trying to strain my brain stuffed with a cold.
Thanks again to all! This works like a charm! Just have to adjust my triggers now.
And try to make it through today. TGIF!
Kathy
-----Original Message-----
Sent: Friday, December 07, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L
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
[EMAIL PROTECTED]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
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 -- [EMAIL PROTECTED] -- 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" <[EMAIL PROTECTED]>
> 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
> [EMAIL PROTECTED]
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
