Help with Command Text.

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

From: Russell Verdun (cpa44_at_hotmail.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 15:43:13 -0500

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.

Relevant Pages

  • Re: Oracle procedure raises exception but looks to be successful from DBI
    ... is the more desirable syntax for calling oracle procedures. ... because DBI's execute method returned success even though the ... procedure raised an exception. ...
    (perl.dbi.users)
  • Re: Oracle procedure raises exception but looks to be successful from DBI
    ... is the more desirable syntax for calling oracle procedures. ... because DBI's execute method returned success even though the ... procedure raised an exception. ...
    (perl.dbi.users)
  • [NEWS] Multiple Vulnerabilities in Oracle Database (Trigger, Extproc, Wrapped Procedures, PL/SQL Inj
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the Oracle database server. ... Oracle Trigger Abuse ... written in PL/SQL and execute with the privileges of the definer/owner. ...
    (Securiteam)
  • Re: Debug ORA-03113 on Oracle XE
    ... a laptop that runs the Oracle 10g Express ... The query returns no rows with the current data set but it's pretty ... If Oracle XE generates further info I don't know where I ... Usually, when you install Oracle, the UTL_FILE package is installed, EXECUTE is granted to PUBLIC, and a public synonym is created. ...
    (comp.databases.oracle.server)
  • Re: Waveform Mini-Language
    ... The syntax might seem strange at first, ... Got any ideas for how to make a "go" command ... How about "Frequency 500 Hz Voltage 20 Volts Set"? ... Frequency would error check and execute it. ...
    (comp.arch.embedded)