Thanks for the question, Tapas .
Asked: May 14, 2018 - 8:52 am UTC
Last updated: May 21, 2018 - 7:27 am UTC
Version: 11.1.2.2.0
Viewed 1000+ times
You Asked
Hello,
We have web based forms(version : 11.1.2.2.0) running in Windows 7 environment.
In the first screen (in WHEN-NEW-FORM-INSTANCE trigger),
we are using D2KWUTIL's functions -
DECLARE
l_userprofile VARCHAR2 (2000);
BEGIN
-----
-----
l_userprofile := win_api_environment.get_environment_string ('USERPROFILE');
-----
-----
END;
Issue we faced:
--------------
At run time, we are getting the error message : 'FRM-40734:Internal Error: PL/SQL error occured', when we open this form in Application.
And we found that, this error in occurring because of D2KWUTIL is not deployed properly in the correct path.
Solution we need :
------------------
Instead of Error message 'FRM-40734:Internal Error: PL/SQL error occured' (which is not descriptive),
we want to add a warning message if D2KWUTIL is not deployed properly before using its functions.
(or if we can catch the exact D2KWUTIL error messages instead of 'FRM-40734:Internal Error: PL/SQL error occured' in the forms)
Please help us on this.
Thanks a lot.
Regards,
Tapas
and Connor said...
Just confirming that you're aware that even if D2KWUTIL is working, I'm pretty sure it will be "working" on the server not on the client (because Forms are now web-based). So just making sure that is the use case you are intending.
Other than that, you should be able to catch this by over-riding the ON-ERROR trigger, ie
IF error_code = 40734 THEN
Message('Something internal went wrong - please contact IT Support');
RAISE FORM_TRIGGER_FAILURE;
ELSE
Message(error_type||'-'||TO_CHAR(error_code)||':'||error_text);
RAISE FORM_TRIGGER_FAILURE;
END IF;