APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Success Message in pl/sql!

665735Dec 9 2009 — edited Dec 9 2009

Hi All,

In my apllication i am handling raised application error as shown below:

IF pcount > 0 THEN

RAISE_APPLICATION_ERROR
(-20002,
'Symbol is available in Work in Progress . Click here to go back.'
);
END IF;

it is displaying as it is the error, but for the endsuer will say that is an oracle error. \
So what i have done insetad of that i have use return statemengt as shoen below:
RETURN ''Symbol is available in Work in Progress Click here to generate.';
This will not work in plsql, then i have tried using with

IF pcount > 0 THEN

apex_application.g_print_success_message := ''Symbol is available in Work in Progress please Click here to generate.';

In this case the message is not all displaying at all..
How to handle this scenerio'

Thanks in Advance,
Anoo..

Edited by: Anoo on Dec 9, 2009 8:51 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2010

Added on Dec 9 2009

#apex-discussions

2 comments

951 views