OTN Discussion Forums : page process: user defined error-message ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 2 - Pages: 1 - Last Post: Aug 21, 2008 12:58 AM Last Post By: Christian Roppo...

Christian Roppo...

Posts: 116
Registered: 07/06/08

page process: user defined error-message
Posted: Aug 21, 2008 12:08 AM

hi to everyone!

i want to display a user-defined error-message, if for example a select in an anonymous PL/SQL block returns more than one row. i tried it with an user defined exception, but i get allways the success message... how can i do that?

thanks for your help.

bye,
christian

pjturley

Posts: 330
Registered: 09/07/05

Re: page process: user defined error-message
Posted: Aug 21, 2008 12:37 AM

in response to: Christian Roppo...

Hi,

In the exception handler of your PL/SQL process use this :-

apex_application.g_print_success_message := '<span style="">Error message</span>';

Regards

Paul

Christian Roppo...

Posts: 116
Registered: 07/06/08

Re: page process: user defined error-message
Posted: Aug 21, 2008 12:58 AM

in response to: pjturley

thanks a lot!

bye,
christian

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)