Call Oracle Function from VB.Net

[Gary]

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.

[Cor Ligthert]

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

[Paul Clement]

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)