Solved

Can I send a Windows message box from pl/sql?

Posted on 2001-06-20
6
1,630 Views
Last Modified: 2008-02-01
I know I can raise an exception and have the message bubble up to the windows client as a message box to let the user know there is an error through pl/sql RAISE statements and exception handling, but how can I send a message box to windows if the process is successful?
0
Comment
Question by:billgough
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 1

Expert Comment

by:EugeneGardner
ID: 6212855
Are you running PL/SQL using the database engine or via another mechanism such as Developer 2000 ?
0
 
LVL 4

Expert Comment

by:srikant033100
ID: 6213252
How ur sending the error message through the messaage box to the client.

Srikant
0
 

Author Comment

by:billgough
ID: 6214136
PL/SQL on the database, not through a developer tool.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Expert Comment

by:HuzaifaMerchant
ID: 6214590
you can use raise_application_error function to raise an application error from pl/sql. i think you should be able to handle the error in the client like you handle any oracle error using the error number and message.
0
 

Author Comment

by:billgough
ID: 6214666
Yes, I have used that in the past...for errors.

...however, using error handling when there isn't an error does not sound like a good practice to me, hence the call to see if there is a similar way to do it without using RAISE or RAISE_EXCEPTION_ERROR.
0
 
LVL 2

Accepted Solution

by:
vanmeerendonk earned 50 total points
ID: 6224410
And the old fashion way: call a function on the server
that returns and errorcode 0 when correct and display an alert when the code is 0????
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question