Solved

Oracle function from VB.NET

Posted on 2006-11-21
2
308 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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