| Warning Message [message #192996] |
Thu, 14 September 2006 09:17  |
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
|
Senior Member |
|
|
Hi,
Hope i will get answer for my query.
I have one problem regarding warning message.
In one procedure i want to just disply warning to user and proceed ahead.
How can i do in folowing procedure
========================================
CREATE OR REPLACE PROCEDURE prc_test(load_quantity_diff number
) AS
begin
IF load_quantity_diff > 0 THEN
RAISE_APPLICATION_ERROR(-20001, 'test');
end if;
......
Further procedure
.......
end;
=======================================
In this procedure i dont want to give RAISE_APPLICATION_ERROR .But i want to give just warning & proceed ahead.
========================================================
Please let know anything about the query.
Waiting for positive reply.
It's an urgent.
Thanx in advance.
Amol
|
|
|
|
|
|
| Re: Warning Message [message #193002 is a reply to message #192996] |
Thu, 14 September 2006 09:27  |
bhoite_amol83
Messages: 110
Registered: June 2005
Location: Pune
|
Senior Member |
|
|
Hi Mahesh,
Thanx for your quick reply.
But, i cant able to show my message to the user. because i want this message to be displayed on the front end;
Waiting for reply.
Amol.
|
|
|
|
|
|
| Re: Warning Message [message #193017 is a reply to message #193009] |
Thu, 14 September 2006 09:58 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You could have a lok at DBMS_ALERT - you can set up alerts to wait to be triggered, and use that to asynchronously pass info to the client.
There is no real way of interrupting the processing to return to the client, display a message, and then continue server processing from where you left off.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
