One way I have done it in the past was create an exception handling package and then called it from within other packages.

Not much help sorry.

Luis

-----Original Message-----
From: Roger TEDMAN [mailto:oracledba-ezmlmshield-x29139738.[Email address protected]
Sent: 05 March 2008 14:08
To: LazyDBA Discussion
Subject: packaged exceptions


Hi all,

I have a package containing several procedures (no surprise there), and I want to set up a common exception handler. I can create a declaration globally, but can I create a handler also?

R




> Message du 05/03/08 14:47
> De : "Sikyala Raquel [USA] "
> A : "LazyDBA Discussion"
> Copie à :
> Objet : RE: How to get rid of expiration on password
>
> Thanks! That worked.
>
>
> -----Original Message-----
> From: SriRagava Srinivasarao k [mailto:[Email address protected]
> Sent: Wednesday, March 05, 2008 3:53 AM
> To: Sikyala, Raquel [USA]
> Subject: RE: How to get rid of expiration on password
>
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email, **and removed
> any attachments, and kept your email address secret **from this person,
> and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal **Anything below this line is the original email text
>
>
> HI
>
> In Profile change the below paramteter
>
> PASSWORD_LIFE_TIME UNLIMITED
>
>
>
> -----Original Message-----
> From: Sikyala Raquel [USA]
> [Email address protected]
> Sent: Wednesday, March 05, 2008 2:11 AM
> To: LazyDBA Discussion
> Subject: How to get rid of expiration on password
>
> How can I change a database user account so that the users password
> never expires?
>
> What is the syntax?
>
> Thanks!
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768833). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com

Oracle LazyDBA home page