Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2001-06-20
6
Medium Priority
?
1,711 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
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 100 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

571 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