Re: ODBC and stored procedures???

In article <3300016E.BF7@exesolutions.com>, "Daniel A. Morgan" <dmorgan@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