Home » SQL & PL/SQL » SQL & PL/SQL » Warning Message
Warning Message [message #192996] Thu, 14 September 2006 09:17 Go to next message
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 #192999 is a reply to message #192996] Thu, 14 September 2006 09:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use dbms_output.put_line to display some warning message.
Re: Warning Message [message #193002 is a reply to message #192996] Thu, 14 September 2006 09:27 Go to previous messageGo to next message
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 #193009 is a reply to message #193002] Thu, 14 September 2006 09:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Apologies. It will not work for front-end.
I have no idea how you would do it in 'front-end'.

Re: Warning Message [message #193017 is a reply to message #193009] Thu, 14 September 2006 09:58 Go to previous message
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.
Previous Topic: need help in NOT IN subquery
Next Topic: replace colum value
Goto Forum:
  


Current Time: Tue Dec 06 12:34:54 CST 2016

Total time taken to generate the page: 0.19390 seconds