Skip to Main Content

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!

Exception Massage In page Process

VedantNov 11 2011 — edited Nov 11 2011
Hi,
I want to display massage of Page process exception on screen as we show validation Massage.

I am writting display massage statement like
HTP.p('Error: '||SQLERRM);
but it is not handling exception massage.
what should i write in place of HTP.P to print the massage of page process exception on screen.

UPDATE TA_QUOT_DTL A SET FROM_POINT = ( SELECT POINT_ID FROM TA_QUOT_DTL B
WHERE A.QUOT_ID = B.QUOT_ID
AND B.QUOT_LINE_ID = LPAD(A.QUOT_LINE_ID - 1,8,'0')
) WHERE QUOT_ID = :P4_QUOT_ID;
exception
when others then
HTP.p('Error: '||SQLERRM);    

htp.p(' ');
end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2011
Added on Nov 11 2011
7 comments
756 views