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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runtime error 'Call to procedure "&P1" failed'

Status
Not open for further replies.

Mockenrue

Programmer
May 15, 2002
40
NL

I have a 6i form with a button that performs a GO_BLOCK statement to navigate to another block. When omitting a required field before pressing the button, Forms detects this but the error message seems incomplete:

'Call to procedure "&P1" failed'

I can circumvent this by preceding the GO_BLOCK statement by:

VALIDATE('RECORD_SCOPE');
IF NOT FORMS_SUCCESS THEN
RAISE FORM_TRIGGER_FAILURE;
END IF;

In that case the correct message 'FRM-40202 Field must be entered' is raised,
however, the cursor is not placed in the omitted required field anymore, which is
confusing for the user.

Questions:
- Why is the &P1 parameter not substituted ?
- In 2nd case, why is the cursor not automatically positioned in the omitted field ?
 
Forms does not use & as a placeholder in pl/sql.
Forms prohibits from LEAVING an empty mandatory field, but how shall it work if there are 2 empty fields? Try to develop more specific logic.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top