Solved

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

Posted on 2014-07-31
6
478 Views
Last Modified: 2014-08-07
HI,

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
0
Comment
Question by:Wayne Barrt
  • 3
  • 2
6 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 40232017
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.
0
 

Author Comment

by:Wayne Barrt
ID: 40232063
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
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40232809
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.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Wayne Barrt
ID: 40245368
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.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40245831
>> 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:
http://jeremybranham.wordpress.com/2011/04/25/oracle-instant-client-with-odp-net/
0
 

Author Comment

by:Wayne Barrt
ID: 40246099
Thanks much for the feedback.. I'll let you know how i make out..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create a nested synonym 4 28
SQL2016 to ORACLE11G linked-server 6 28
oracle collections 2 22
Migration from sql server to oracle 5 26
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

831 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