Error in calling stored procedure via DB link
- From: "Deva" <Deva@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 Aug 2005 12:33:04 -0700
Hi,
I have a VB client that calls a stored proc sp1 in an oracle server.
The stored proc sp1 inturn calls another stored sp2 in another oracle server
via dblink.
This works fine.
If I try to call the stored proc sp2 directly by saying sp2@dblink() then it
fails.
The error that I get is "-2147217900 : Syntax error in {call.."
Here is the code snippet.
With oCommand
.ActiveConnection = oAdoConnection
.CommandType = adCmdStoredProc
.CommandText = "BUILD_NUMBER@NEW_LINK"
.CreateParameter("in_IDENT",adChar,adParamInput ,10,strIdent)
.CreateParameter("out_NO OUT",adChar,adParamOutput ,10,strOUT)
End With
oCommand.Execute
Please help me out.
Regards,
Deva.
.
- Follow-Ups:
- Re: Error in calling stored procedure via DB link
- From: Paul Clement
- Re: Error in calling stored procedure via DB link
- Prev by Date: Adodb.Recordset Async query in vb6 and xp - IDE Vanishes
- Next by Date: How To Change FieldSize Using ADO
- Previous by thread: Adodb.Recordset Async query in vb6 and xp - IDE Vanishes
- Next by thread: Re: Error in calling stored procedure via DB link
- Index(es):