Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

By: Answerout


Here is the solution for Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?. The solution is given after the options.

Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF

IF ERROR_CODE = 40509 THEN MESSSAGE (SQLERRM);

IF ERROR_CODE = 06512 THEN MESSSAGE(DBMS_ERROR_TEXT); END IF;

IF ERROR_CODE = 06512 THEN MESSSAGE (SQLERRM);

IF ERROR-CODE = 20101 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF;

IF ERROR_CODE = 20101 THEN MESSSAGE(SQLERRM);

Correct Answer

IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF

Explanation:

IF ERROR_CODE = 40509 THEN MESSSAGE (DBMS_ERROR_TEXT); END IF is the answer for Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?

Conclusion:

are provided by Answerout to teach the newcomers in the Digital Marketing Industry. The answers provided are 100% correct and are solved by Professionals. We don’t and never have recommended using these answers as a cheat sheet. We keep updating our answers as the Exam Change. You can also send us an Email or Comment to notify us of any support or Changes.

comments
leave comment