Call Oracle Function from VB.Net

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
¤ 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.aspx?scid=kb;en-us;321718&Product=adonet


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top