Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Topic: FRM-01403 ora-01403 not data found

Status
Not open for further replies.

pondo

Programmer
Jun 17, 2000
16
US
I have a forms ver. 5.06.20.0 fmb file (everything runs fine) I compiled and converted up to 6.0.8.11.3 (no involvement generating from Designer) ...now when I go to invoke a procedure in an attached library of the form in the updated ver. 6.0.8.11.3 , all of a sudden the procedure doesn't work(get the 'FRM-01403 ora-01403 not data found' error message) The procedure is called in the following way:
/* CGBG$WHEN_BUTTON_PRESSED */
/* Perfoming Procedure/Call */
BEGIN
insert_company;
IF NOT form_success THEN
MESSAGE('Error: PL/SQL held against Button failed to execute');
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;

The error message text 'Error: PL/SQL held against Button failed to execute' never appears, just the 'FRM-01403 ora-01403 not data found' error message

Would any of you have any idea how I should handle this?
 
Try to check whether on-message trigger exists. Your message may be trapped by some more robust procedure, e.g. translating message text or showing the alert. And also if insert_company raises error, it is not trapped by the statement below, but rather processed by callers exception handler if any or some on-error trigger. Try to write your own exception handler.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top