Re: ODBC and stored procedures???

Hi I dont know how compatible Oracle is with Sybase. As for as stored procedures go, even if ODBC does not handle such a function (I am not sure if it does) you can work around the problem. Use a database trigger to activate the stored procedure and use a dummy table operation to activate the trigger. this way you bypass the ODBC altogether. Good Luck ! Chaminda Peries On 3 Feb 1997, Feng Huang wrote: } Hi, ODBC experts, } } I've got a question regarding ODBC and stored procedures. Suppose I need to } write an application with ODBC accessing Oracle and Sybase. 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? The programming language will be C++. Both client and server will be } on Unix. So I guess I need to find some Unix driver as well. } } How well is the ODBC API with respect to calling stored procedures, or this } is purely up to the driver implementation? } } I'd appreciate any help from you. Thank you very much. } } } --Frank } fhuang@cs.umd.edu } }