data view web part with custom query

[David McKenzie]

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 Buyens]

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)
|/---------------------------------------------------
*----------------------------------------------------

 

[John Jansen \(MSFT\)]

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.