| ON-ERROR CONTINUED..... [message #79339] |
Mon, 27 May 2002 10:13  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
