Re: Trigger exception problem

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).