oracle odp run procedure and direct all output from that procedure execution to textbox


I need to run a procedure in Oracle, from a Windows form application created in Visual Studio .Net, but have all output from that procedure execution directed to a textbox in the application.  (I do not wish to use Console mode).  The procedure has exception handling and i would like to capture any exception messages to a textbox.  If you executed the procedure from SQLPLUS in a command window, the messages that would show, is want I would like to capture to the textbox, as an example.  I have looked at Oracle notifications functionality but that does not seem to be usable for my requirement.  Can someone suggest a high level explaination of a method to use or an suggest an article that may describe the method to use.  thanks Barry
Wayne BarrtCEOAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

does the procedure write to dbms_ouput?

if so, you can call the dbms_output package from within your .net app to read that buffer and put the results into your text box.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Wayne BarrtCEOAuthor Commented:
Hi Sean, no.. i didnt add dbms_output command.  I think that will do the trick.. I will try that.. thanks much for your quick answer and help.  Barry
slightwv (䄆 Netminder) Commented:
Even though you've already selected an answer to this:
I do a lot with ODP and .Net web apps.  If the procedure generates an exception it can be trapped in .Net and handled however you want to handle it.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Wayne BarrtCEOAuthor Commented:
Hi Slightwv.. thank you for your reply.  I have a new question on using ODP.. I need to create a deployment package for my Windows Form app, including the ODP references and wondering what is the best deployment package to use e.g. WiX or  Install Shield Lite.  I'd like to know can it include and install the ODP references cleanly.  Have you tried using either methods?  I havent started the deployment step but have read some negative reviews of using Install Shield Lite and can incorporate the ODP references.  thanks.
slightwv (䄆 Netminder) Commented:
>> Have you tried using either methods?

Unfortunately deployment of .Net apps is outside my area of expertise.  I mainly do back-office web apps and 'deployment' is copying files from the dev box to the Intranet server.

There are some references around that all you really need for ODP to 'work' is 5 of the DLLs copied into the same folder as the app so you really don't need a 'complete install' of ODP.

I've done this once or twice for a couple of console apps and it does work.  Not sure about winforms...

This is the first link I found that talks about the magic 5 files:
Wayne BarrtCEOAuthor Commented:
Thanks much for the feedback.. I'll let you know how i make out..
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

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.