By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,885 Members | 1,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,885 IT Pros & Developers. It's quick & easy.

Call Oracle Function from VB.Net

P: n/a
Hi Al

I have the following parameters in an oracle function

PACKAGE BODY ALLO A
-------------------------------------------------------------------------------

FUNCTION ITEM (O_error_message OUT VARCHAR2
O_item IN OUT item.item%TYPE
RETURN BOOLEAN IS......

Can anyone assist with how I go about calling this from VB and pass the O_item output back to VB. Any assistance anyone could provide would be appreciated

Thanks in Advance.
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi Gary,

You better can ask this in the newsgroup
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:
<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

There Miha and Kevin answer all Oracle related questions.

I hope this helps a little bit?

Cor

Nov 20 '05 #2

P: n/a
On Tue, 27 Apr 2004 23:56:02 -0700, "Gary" <an*******@discussions.microsoft.com> wrote:

Hi All

I have the following parameters in an oracle function:

PACKAGE BODY ALLO AS
--------------------------------------------------------------------------------

FUNCTION ITEM (O_error_message OUT VARCHAR2,
O_item IN OUT item.item%TYPE)
RETURN BOOLEAN IS.......

Can anyone assist with how I go about calling this from VB and pass the O_item output back to VB. Any assistance anyone could provide would be appreciated.

I would highly recommend using a stored procedure for this instead of attempting to call the
function directly:

HOW TO: Call Oracle Stored Procedures in Visual Basic .NET with the Microsoft Oracle Managed
Provider
http://support.microsoft.com/default...Product=adonet
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.