Re: ODBC and stored procedures???

In article <3300016E.BF7_at_exesolutions.com>, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> writes
>> I'm not an ODBC expert, but I can tell you that stored procedures under
>> Sybase are entirely different than stored procedures under Oracle.
>> Sybase (and MS-SQL Server) stored procedures can return result sets to
>> the client.
>
>True but there is a workaround. You can have your Oracle procedure
>return values to a view and attach to the view.

What? You will have to explain that one in more depth.
>

The nearest equivalent to returning a result set is the use of cursor variables.

You declare a variable of type cursor and pass it to a procedure as a reference parameter. The procedure opens the cursor (effectively executing the query) and returns. The calling program then fetches from the cursor. This can be done in PL/SQL or in Pro*C, but I would be surprised if ODBC could make use of it.

BTW, why are we discussing Oracle in an article cross-posted to every database group except oracle? I have added comp.databases.oracle.server to the list.

-- 
Jim Smith