data view web part with custom query

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?

Jim
Sat May 29 22:08:21 CDT 2004

Try accessing the data by means of a view rather than a
stored procedure.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------



>-----Original Message-----
>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?
>
>
>.
>

John
Mon Jun 07 13:34:15 CDT 2004

When you use CUSTOM sql statements (whether to Oracle or SQL server or
whatever), the server needs to be enabled for this. You should make sure
that the server admin pages are configured to enable passthrough queries.
Also be sure the user and password have permission to view your stored
procs.

--
Thanks!
John Jansen
Microsoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.
"David McKenzie" <DavidMcKenzie@bonbon.net> wrote in message
news:uJuiGkPREHA.3720@TK2MSFTNGP09.phx.gbl...
>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?
>
>