Solved

Oracle function from VB.NET

Posted on 2006-11-21
2
312 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: 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

Suggested Solutions

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
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…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 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