This is what I encountered.

PHP Code:
'Connection String Definitions.
Public Const QUOTE As String = """"
Public Const gConStr As String = "Provider=MSDASQL.1;Extended Properties=" & QUOTE & "DSN=qldev;UID=devuser;PWD=pwd123;SERVER=devserver;" & QUOTE
Public Const gConStr As String = "Provider=MSDAORA.1;Password=pwd123;User ID=devuser;Data Source=devserver" 
Only one of the above providers will let me capture the output from the stored procedure.

Code:
Private Function GetXML(iQuoteNo As String, iLangCode As String) As String
Dim ladoCmd As New ADODB.Command
Dim lParam As ADODB.Parameter
Dim lStr As String

ladoCmd.ActiveConnection = gConAdo
ladoCmd.CommandType = adCmdStoredProc
ladoCmd.CommandText = "sp_getquotexml"
Set lParam = ladoCmd.CreateParameter("iquoteno", adVarChar, adParamInput, 6, iQuoteNo)
ladoCmd.Parameters.Append lParam
Set lParam = ladoCmd.CreateParameter("iLangCode", adVarChar, adParamInput, 2, iLangCode)
ladoCmd.Parameters.Append lParam
Set lParam = ladoCmd.CreateParameter("oXML", adLongVarChar, adParamOutput, 100000)
ladoCmd.Parameters.Append lParam
ladoCmd.Execute

lStr = ladoCmd.Parameters("oXML").Value
GetXML = lStr
End Function
My entire application is working using the other connection string.

The next part is to to transport this XML to a java webservice. I don't understand why the webservice cannot call the stored procedure that I have out there. I am going to scream.