smacca
asked on
How to call an Oracle function directly using OLEDB provider (or otherwise)?
I would like to call an Oracle function directly using OLEDB (or Oracle) connection|command objects?
I have seen examples using OLEDB and "{ call ? ? }" syntax but need one specific to below.
The Oracle function has the following signature is as follows:
FUNCTION get_sscc
RETURN VARCHAR2
Any help appreciated.
Cheers.
I have seen examples using OLEDB and "{ call ? ? }" syntax but need one specific to below.
The Oracle function has the following signature is as follows:
FUNCTION get_sscc
RETURN VARCHAR2
Any help appreciated.
Cheers.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Which execute statement - I assume ExecuteNonQuery
ExecuteNonQuery is correct. Sorry I omitted that. It should come before the
strReturnedValue = cmd.parameters.add("return value").va lue
strReturnedValue = cmd.parameters.add("return
there is a forum at http://forums.asp.net/967327/ShowPost.aspx that discusses this in some detail; ajagadeesh presents an oledb method for accessing oracle functions.
p.s. The policy of experts-exchange prohibits me infringing copyrights by copying/pasting code from another website to this website.
Hope this helps.