I think that's probably an overcomplication of the issue..
One thing you could do, Magy is to just create a function that accepts the same parameters as the Oracle SP and then call the Oracle
SP in the function and return any necessary data.
As far as the question of should you do it in a web method or in vb is a matter of the target that you need. Remember that making
the calls in binary code will be much faster then having the extra overhead of serializing the data to XML and back (Not to mention
the "fluff" that is added and transferred over the wire). In that case, maybe a middle tier data layer component would be the best
solution.
If you are exposing this SP to many different people and platforms then making it a web service would probably be your best bet.
And if you need a combination of the two then you could always create a middle tier (Either copy the assembly with your app or set
it up on a server and use Remoting) and then have your web service call the middle tier component.
Hope this helps!
Scott
"Drew Marsh" <dr****@hotmail.no.spamming.com> wrote in message news:82*********************@msnews.microsoft.com. ..
What would be the best way to execute a Oracle stored procedure that
excepts several input paramters, through a web method in vb.net. What
would be a good way to get to the web method, the Oracle stored
procedure's definition; the name of the proc. and all of the parameter
information such as name, value, type and value. I'm looking for the
best method. Any ideas.
I offered a solution to this problem a couple days ago. Check out this thread[1].
HTH,
Drew
[1]
http://groups.google.com/groups?q=si...phx.gbl&rnum=1