Re: Can you solve this? ODBC call to a stored procedure

You can't do it directly. The problem is that stored procedures cannot return cursors which are required for result sets.

The normal way is a temporary table. You can also do it (crudely) by building a very big string that is the result concatenated together.

The concept just isn't supported properly.

Todd Verstraten
mailto:tverstrat_at_tier3.com
http://www.tier3.com

Le-Chin Eugene Liu <philt_at_u.washington.edu> wrote in article <58l307$i1s_at_nntp1.u.washington.edu>...
> Has anyone ever successfully made an ODBC call to a stored procedure
> using MS Access or MS Query, or any other tools besides SQL Plus that
> would return a dynaset or a record? This is so trivial with MS SQL Server
> and Sybase but it seems so hard to do with Oracle.
>
> Simply put, all I want is to get "select * from tablename" statement's
> output by using a stored procedure through any ODBC driver, not SQL Plus.
 

> Can this be done ???
>
> Thanks,
>
> Phil
>
Received on Wed Dec 11 1996 - 00:00:00 CST