473,320 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

help with passing stored procedure meta data to web method.

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.

Magy
Nov 21 '05 #1
4 2327
> 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=

Nov 21 '05 #2
Drew
I like Russell am no that versed in XML, can you answer a few questions
please. Do you know of any good sources/books that I can learn how to create
and use XML schema in vs.net? I see what you mean I can simply create in my
shcema an element for each of my stored procedures, which will have all the
parameters def's as well, and use a reader to locate the proc. def. I want
to use, and access the information to programmatically create my command
objet and execute the proc. on the web service. Am I correct?

Thanks.

Mag
"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

Nov 21 '05 #3
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

Nov 21 '05 #4
Scott Meaddows wrote:
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.


Absolutely. It was my interpretation that she was looking for the ability
to execute any arbitrary command. If you have specific commands that you
need to execute then you should definitely just go with a web method per
command with matching parameter lists as Scott suggests.

-Dre

Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft...
2
by: Dino L. | last post by:
How can I run stored procedure (MSSQL) ?
4
by: Mike Dinnis | last post by:
Hi, I've been working through a number of turorials to try to learn more about retrieving data from a SQL database. I think i've mastered techniques where i create a sql string in the page and...
6
by: Rod Snyder | last post by:
I'm trying to set up a page with an asp.net link button that would send a user to a certain page and on page load execute a specific stored procedure tied to the button on the previous page. The...
4
by: DOTNET | last post by:
Hi, Anybody help me regarding this error: I am assigning the values to the session variables when the button is clicked and passing these session variables to the next page and when I am...
6
by: James Radke | last post by:
Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...
0
by: r1 | last post by:
I am relatively inexperienced in using delegates and asynchronous methods. I read several articles, and then I developed my own code with a mission to improve the performance. Wow! I cannot...
15
by: Jay | last post by:
I have a multi threaded VB.NET application (4 threads) that I use to send text messages to many, many employees via system.timer at a 5 second interval. Basically, I look in a SQL table (queue) to...
0
by: boyindie86 | last post by:
Hi Forum, I am having some really iritating problems with an simple input page which should pass parameters into a stored procedure from the text boxes first and last name. I keep getting the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.