data view web part with custom query

From: David McKenzie (DavidMcKenzie_at_bonbon.net)
Date: 05/28/04 

Date: Fri, 28 May 2004 16:16:27 -0500

I would like to call an Oracle stored procedure from the Custom Query of a
Data View Web Part
(The query i wish to run has a join, so i can't just specify rows and
filters)
I have tried entering the SP name and "execute sp_name") but just get "the
database has returned an unexpected result" or some such.
The SP executes fine in an Oracle environment, and the database is reachable
(albeit one table at a time) in the data vies.

What am I missing?

Relevant Pages

  • Re: DBRW generating ADODB.Command error 800a0cc1
    ... Off topic - the formula you are using for max and min Longitude is accurate only at the equator. ... Ron Symonds ... > Database Results Wizard Error ... >> Don't place the code in the custom query. ...
    (microsoft.public.frontpage.programming)
  • Re: Access and Front Page 2003 -- Syntax Error
    ... Did you tried in the custom query changing all the "" ... | they support Access DB's but don't support the Access Web View portion ... Started off by importing an access 2003 database into Front Page ... and got "database results wizard failed. ...
    (microsoft.public.frontpage.client)
  • Database Results Wizard Error: 817029
    ... need to a parameter to a custom query using sum: ... Database Results Wizard Error ... The DRW is really of limited value if one can't make select statements work ... with 'distinct', 'sum', 'count' and a form parameter. ...
    (microsoft.public.frontpage.programming)
  • re: Criteria in Database Results
    ... I am encountering an error while trying this custom query. ... The following error message comes from the database driver ... Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.frontpage.programming)
  • Execute stored procedure via web method.
    ... >From a vb.net application I'm want to execute an Oracle Stored Procedure via ... Oracle Command or the parameter objects object to the Webservice, ... How would I get the parameters to the web method? ...
    (microsoft.public.dotnet.framework.webservices)