?
Solved

Oracle function from VB.NET

Posted on 2006-11-21
2
Medium Priority
?
321 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 1500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

580 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