> Option 3: Use stored Procs for cause the > differences are fewer? A few things that I've run into with Oracle.
Oracle supports named parameters but not through their OLE DB provider (at least I've never gotten it to work reliably). So when using the IDataParameter interface set the ParameterName property no matter what. The OleDb provider by Oracle ignores it when actually calling the stored procedure. The Oracle Managed Client by MS requires it. I'm not sure what the managed provider from Oracle will require (if/when it is released). Be real careful with result sets returned from stored procedures. SQL Server just lets them fly out of the SP. Oracle requires you use refcursor parameters. How do I get around this?? SPs never return anything except normal data types. If I need a result set, I use a VIEW. Works pretty well for me. Justin Rudd http://www.pinetree-tech.com/ http://radio.weblogs.com/0107260/ You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
