| error handling [message #77704] |
Tue, 06 November 2001 01:44  |
lakshmi
Messages: 22
Registered: July 2000
|
Junior Member |
|
|
Hi All,
I have created a trigger(before insert or update for each row)at the back end and handled the exceptions
as
raise_application_error(-20000,'NEED_BY_DATE CANNOT BE NULL');
it is compiled finely and showing the errors at the backend perfectly.
But i was not able to see these errors at the front end(D2K)
Please give me the suggestion
Lakshmi.
----------------------------------------------------------------------
|
|
|
|
| Re: error handling [message #77711 is a reply to message #77704] |
Tue, 06 November 2001 16:34  |
N.N.
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
You can message out the error by using
dbms_output.putline ('my error');
N.N.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
