Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Executing and Oracle stored procedure via a web method in vb.net

Re: Executing and Oracle stored procedure via a web method in vb.net

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 25 Nov 2004 09:57:12 +0100
Message-ID: <co46p9$f44$1@news.BelWue.DE>


Ted wrote:
> Can anyone help me with the syntax that would be used to execute an
> Oracle stored procedure from vb.net. I don't recall the exact syntax
> but, it used a Call statement. I gather this is similar to SQL's
> Execute statement. Actually I want to mimic this text:
>
> dim cmd as sqlcommand
> cmd.CommnadText = "Execute <mySP> @Parm1 = 12, @Param2 = 'Jim' "
>
> How can this be done with Oracle. Again I saw somewhere, the use of a
> call statement, I gather it would replace the Execute as in SQL. I
> would appreciate any thoughts and advice on the syntax.

http://otn.oracle.com has a vast section on odp.net where you will find as many examples as you wish plus documentation of the classes implemented in ODP.NET. There is also a link to a microsoft page with comparison of features of ODP.NET and the microsoft supplied oracle driver (I don't remember it's name). Since the ODP.NET driver is more complete with regards to support of oracle specific features, I'd strongly suggest you use it, with on exception: when your clients versions are, for what reason ever, < 9iR2.

One word of caution: Since you seem to bee unable to build an Oracle equivalent of your MS SQL call, I dare say that you lack some basic knowledge about Oracle which could do with a little improvement.

http://tahiti.oracle.com has the whole Oracle Documentation, but you easily get lost due to the mass of information thats available.

So you might also want to invest in some good books, unfortunately one of the best I've come across for beginners is no longer available because the publisher, Wrox Press, is out of business. (It was called Beginning Oracle Programming if memory serves).

The next two books I'll buy myself on PL/SQL Programming are the ones by Steven Feuerstein and Connor McDonald, perhaps you want to take a look at them.

HTH
Holger Received on Thu Nov 25 2004 - 02:57:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US