Solved

Oracle function from VB.NET

Posted on 2006-11-21
2
305 Views
Last Modified: 2010-04-23
Does anyone know how to call a oracle function directly from VB.net?  Thank you.
0
Comment
Question by:Sanmarie
2 Comments
 
LVL 8

Accepted Solution

by:
doobdave earned 500 total points
ID: 17995048
Hi,

I would think you need to use ADO.NET to do that.

Create a connection object, and a command object.
Set the command object's text to be the call to the Oracle function.
Open the connection object and execute the command object.

Best Regards,

David
0
 

Author Comment

by:Sanmarie
ID: 17996184

We are using the OLEDB object not oracle client. We did what you are describing but it is throwing an exception. We read that it might work  if we use the oracle client.

Nevertheless, we have decided to embed the function in a stored procedure to get it to work. Thanks for your help

San
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

912 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now