Skip to Main Content

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TableAdapters and stored procedures

482211Jan 11 2006 — edited Feb 14 2008
Anyone know if there is any support for Oracle using stored procedures with a TableAdapter?

For those unfamiliar with this feature in VS 2005, we create a strongly typed DataSet, put a table on it using the designer, add/configure a TableAdapter and enter the TableAdapter Configuration Wizard. From here, we choose a connection string, then the next wizard step asks "How should the TableAdapter access the database?" Using an Oracle connection string, the only option that is not disabled is "Use SQL statements".

At this step, for an SQL Server connection string, we can select "Use existing stored procedures", which is what we want to use now with Oracle 9i R2. We've been using SQL DML statements quite happily with TableAdapters so far, and had not really noticed that this feature would not be available for Oracle. Unfortunately, we now need to use stored procedures, and we quite like the TableAdapters --- once you get over the rather obvious coupling of data access to the DataSet, not having to write so much code to use DataAdapters is quite nice.

I've read a little about the ODT, and the Oracle Explorer stuff looks pretty cool, but if I go to the trouble of installing the ODT, will it fix my TableAdapter stored procedures problem? Are there any other tools or workarounds?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2008
Added on Jan 11 2006
9 comments
7,691 views