Include User
Notifications or Custom Messages and Error Messages in Oracle APEX’s default
Success and Error Message style.
Default
Success message :
Default Error
message :
Steps in
APEX :
ü Step 1 : Create a text field item P11_ENAME.
Step 2 : Create a File Browse Item
P11_FILE_BROWSE and change the Storage Type as APEX_APPLICATION_TEMP_FILES
and Change the Purge File at End of Session.
APEX
Screen :
ü Step 3 : Create an Application Process Insert
Image and copy the below code as source.
Code :
DECLARE
v_blob
BLOB;
v_emp_cnt
NUMBER;
v_name
VARCHAR2 (100);
v_sno
NUMBER;
BEGIN
BEGIN
SELECT blob_content, NAME
INTO v_blob, v_name
FROM apex_application_temp_files
WHERE ID = (SELECT MAX (ID)
FROM
apex_application_temp_files);
EXCEPTION
WHEN OTHERS
THEN
raise_application_error (-20038,
'Table');
END;
BEGIN
SELECT NVL (MAX (sno), 0) + 1
INTO v_sno
FROM emp_files;
--RAISE_APPLICATION_ERROR(-20034,v_sno);
END;
BEGIN
IF :p11_empno IS NOT NULL
THEN
BEGIN
SELECT COUNT (1)
INTO v_emp_cnt
FROM emp123
WHERE empno = :p11_empno;
IF v_emp_cnt = 1
THEN
BEGIN
INSERT INTO emp_files
(sno, empno, file_name, blob_content
)
VALUES (v_sno,
:p11_empno, v_name, v_blob
);
COMMIT;
apex_application.g_print_success_message :=
'<span
style="color : white ">Success :</span>'
|| TRIM (:p11_empno);
EXCEPTION
WHEN OTHERS
THEN
raise_application_error
(-20098,
SQLERRM || '-' || 'INSIDE'
);
END;
ELSE
/* apex_application.g_print_success_message :=
'<span
style="color : white ">Error in Uploading Image for Employee
:</span>'
|| TRIM (:p11_empno);*/
apex_error.add_error
(p_message => 'Employee No : '
|| :p11_empno
|| ' already exists.',
p_display_location => apex_error.c_inline_in_notification
);
END IF;
END;
ELSE
apex_error.add_error
(p_message => 'No value in the Employee
number field.',
p_display_location => apex_error.c_inline_in_notification
);
END IF;
END;
END;
Note : Above code contains two packages. apex_application.g_print_success_message for
Success and apex_error.add_error for Error
Messages. You can change the Message info based on the requirement.
My Custom
Success Message :
My Custom
Error Message : I
have passed the Employee Number in to the Error Notification.
Excellent blog, thanks for Sharing this informative article.
ReplyDeleteOracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Dear very help code, but i need multi image upload in browser who selected 3 image but insert only one impage plz guid me if possible fsd@makramco.net
ReplyDelete