Home » Developer & Programmer » Forms » error handling
error handling [message #77704] Tue, 06 November 2001 01:44 Go to next message
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 Go to previous message
N.N.
Messages: 5
Registered: October 2001
Junior Member
You can message out the error by using
dbms_output.putline ('my error');

N.N.

----------------------------------------------------------------------
Previous Topic: how to populate list item? URGENT!!!
Next Topic: Re: what is the full form of oracle ?
Goto Forum:
  


Current Time: Thu Mar 28 07:27:06 CDT 2024