Re: Cannot find Oracle data client

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: bclegg (bclegg_at_adriley.co.nz)
Date: 04/29/04


Date: Thu, 29 Apr 2004 15:19:53 +1200

Kevin Yu [MSFT] wrote:
> Hi Bob,
>
> It was nice to hear that the problem is resolved. Thanks for sharing your
> experience with all the people here. If you have any questions, please feel
> free to post them in the community.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>
Hi Kevin,
One slight correction is needed on my post.
It turns out that if you are using an SQLServer Client command of
commandtype=text then any parameter name can be used.
ie The command string is "exec proc_SetWidget @Myparam1,MyParam2"

If you specify commandtype =Storedprocedure and use the command string of
"proc_SetWidget" then your parameter names must match what is in the
stored procedure.
I had been using SQlServer client the first way.
When I went to use Oracle client the examples were done the second way.
regards
Bob