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;