Unanswered: OLEDB Calling Stored Procedure via DB Link
Using Oracle and OLEDB I am trying to execute a stored procedure (actually a function) via a database link. When I do this OLEDB throws an "Unspecified error". The SP is fine, I can exec it via sqlplus through the link as well as in some other java code. VB.NET code below that I can't get to work. Any insight would be helpfull (and no I can't change providers...). I think the error is due to the DB Link syntax (@SMSTRANSFER.WORLD), I actually put a local copy of the schema and sp to my connection and this also works fine.
Dim smscmd As New OleDb.OleDbCommand("SUBMIT_TRANSACTION@SMSTRANSFER .WORLD", Me.twrDB, Me.transaction)
smscmd.CommandType = CommandType.StoredProcedure
smscmd.Parameters.Add("RETURN_VALUE", OleDb.OleDbType.VarChar, 100).Direction = ParameterDirection.ReturnValue