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

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?
billgoughAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
vanmeerendonkConnect With a Mentor Commented:
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
 
EugeneGardnerCommented:
Are you running PL/SQL using the database engine or via another mechanism such as Developer 2000 ?
0
 
srikant033100Commented:
How ur sending the error message through the messaage box to the client.

Srikant
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
billgoughAuthor Commented:
PL/SQL on the database, not through a developer tool.
0
 
HuzaifaMerchantCommented:
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
 
billgoughAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.