Re: ODBC and stored procedures???

Feng Huang wrote: ... > We plan to > develop some stored procedures in Oracle and Sybase. Is is possible to make > the application code portable across Oracle and Sybase, and maybe some other > DBMS? 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. Oracle stored procedures can not. All they can do is return a completion code. This severley limits their usefulness, and makes portability a moot point unless all you want from your stored procedures is a completion code. All 3 platforms support this type of stored procedure. There are similar limitations with Oracle triggers. --Rusty