Home » Developer & Programmer » Forms » ON-ERROR CONTINUED.....
ON-ERROR CONTINUED..... [message #79339] Mon, 27 May 2002 10:13 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
I can catch the FRM error for the when button pressed, but the error looks like this...

FRM-40735 when-button-pressed trigger raised unhandled exception, ORA-02292.

So how do I catch the second part (the ORA).
Re: ON-ERROR CONTINUED..... [message #79343 is a reply to message #79339] Tue, 28 May 2002 08:22 Go to previous message
NIK.
Messages: 2
Registered: May 2002
Junior Member
Hi Tyler,
Right, what I think u need to do is to trap the FRM error. ORA messages are database specific. FORMS on-errors/on-messages only trap FORMS errors.
What you could do now is to check in a PRE-DELETE trigger (probably via a cursor) if a child record exists in "child" tables and then trap with appropriate message('Delete no permitted - records exist in table x !') Table being the child table.

Try this way it's more effective.

Let me know what u think Ty.

nik.
Previous Topic: Re: install SQL*Forms30 with Oracle 7.3 - possibly ?
Next Topic: Icon property name.
Goto Forum:
  


Current Time: Thu May 23 05:05:38 CDT 2024