Hi All,
In our application we have an update statement in that exception block i need to display a proper message using HTML tags instead of displaying oracle error message.
some thing like as shown below
apex_application.g_print_success_message := '<span style="color:green">Computer created</span>';
In below update statement line#10 need to replaced with Apex message, is that possible or not.
BEGIN
UPDATE version SET
version =TRIM(:P9_VERSION),
WHERE addin_id = TRIM(:P9_ADDIN_HIDD);
EXCEPTION
when DUP_VAL_ON_INDEX then
raise_application_error(-20001,'Duplicate Found');
when others then
raise_application_error(-20002,'Record is not modified in Update.'||SQLERRM);
END;
Regards,
Sruthitamri