Execute stored procedure via web method.

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

Date: Wed, 24 Nov 2004 16:13:00 -0500

>From a vb.net application I'm want to execute an Oracle Stored Procedure via
a web service. What would be the best way to approach this? I can't pass and
Oracle Command or the parameter objects object to the Webservice, cause
they're not serializable. How would I get the parameters to the web method?
Is there a dynamic P/SQL statement string that I can pass to the web method
and execute it as such? I've been searching for a method and or idea of how
to do this, I would appreciate some professional advice.

Best Regards,

Russ.

Relevant Pages

  • Re: Data table parameter in web services.
    ... So the webservice call is not hard-coded but for example ... which web service to use on a set of data. ... to execute and this string as a generic procdure that will execute the ... one of the web method, it does list it in IE, when i browse the asmx file, ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: ADO.net using ODBC and oracle
    ... > odbc set up propery along with net 8 client. ... > executenonquery statement it gives an invalid sql statement error. ... > also tried to execute simple text sql statments (not stored ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO.net using ODBC and oracle
    ... I am trying to execute a simple oracle stored procedure that has an ... odbc set up propery along with net 8 client. ... executenonquery statement it gives an invalid sql statement error. ... also tried to execute simple text sql statments (not stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is there any body workign with WSE here ?
    ... when you try to execute a Web Method in the Web Service, ... then throw a SOAP exception. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • data view web part with custom query
    ... I would like to call an Oracle stored procedure from the Custom Query of a ... I have tried entering the SP name and "execute sp_name") but just get "the ... The SP executes fine in an Oracle environment, and the database is reachable ...
    (microsoft.public.frontpage.programming)
Loading