Oracle Developer Tools for Visual Studio .NET Release Notes

The latest Oracle Developer Tools for Visual Studio .NET downloads, information, and community forums can be found here:


May 2005

Copyright (c) Oracle Corporation 2005


This file contains important information about Oracle Developer Tools for Visual Studio .NET.  The following topics are covered:

System Requirements


  • .NET framework 1.1 SP1

Support and Product Feedback

Oracle is very interested to hear your comments related to this release, including feature requests and bug reports. Please visit the Oracle Technology Network (OTN )   community forums to tell us what you think!


Ge neral Information and Dependencies

This installation includes Oracle Data Provider for .NET and Oracle10g client

This install includes the following:

  • Oracle Developer Tools for Visual Studio .NET
  • Oracle Data Provider for .NET   - version
  • Oracle Client – version

Do not install Oracle Developer Tools into an Oracle8 or Oracle9 Oracle home

Installing the Oracle Developer Tools into an Oracle8 or Oracle9 Oracle home is not advised. By default, the Oracle Installer will create a new Oracle10g Oracle home.

Visual Studio .NET 2005/2002 not supported in this release

This release does not support Visual Studio .NET 2005 nor  Visual Studio .NET 2002. Please note: support for Visual Studio .NET 2005 is planned when VS.NET 2005 goes production.

Integrated online help

Oracle documentation is installed along with this release and includes context sensitive (F1) help for GUI elements as well as for SQL and PL/SQL keywords. If you do not see the Oracle Developer Tools for Visual Studio .NET book collection in your Visual Studio .NET help collection, use the "Visual Studio Combined Help Collection Manager" (search for “VSCC” in the online help) and enable the Oracle Developer Tools for Visual Studio .NET book collection.

Localization Support

The following languages are supported:   English, German, French, Italian, Spanish, Japanese, Korean, Simplified Chinese, Traditional Chinese. The installation steps may show additional languages that are not supported.

Local Database option may not be visible from connection dialog drop down list

In order for a locally installed database to show up as a “Local Database” in the connection dialog box, Oracle Developer Tools must be installed in the same Oracle10g Oracle Home as the database. If the tools are installed in a separate Oracle home from the database, the Oracle NET Configuration assistant will need to be used to create an alias for the database.

To Deinstall, run Setup.exe or use Oracle Universal Installer

This installation does not install the Oracle Universal Installer. If you have already installed the Universal Installer as part of some other product, you may run it from the Programs menu and choose "Deinstall products". Otherwise, run the Setup.exe that was provided with this installation and choose "Deinstall products".

Features not Covered by Documentation

Preview SQL
  • The "preview SQL" button on the various object designers shows the SQL that will be executed on the database to create or modify that object.  It is often  possible that there is not yet any SQL to execute and therefore a blank box is displayed.

PL/SQL Code Editor
  • Pressing F1 in the task list will provide help for the Oracle error number
Oracle Query Window
  • File->Open of a .SQL file while Query Window is open, will load that file into Query Window. File->"Save Selected Items" will save the contents of Query Window to a file
  • Users can drag and drop tables/views/table columns/view columns from Oracle Explorer onto Query Window to generate SQL.
  • All SQL is committed immediately. "Commit" and "Rollback" commands are accepted but have no effect.
  • Every line in a SQL script will be committed immediately. Existing  SQL Scripts that contain "commit" and rollback" statements should be modified if neccessary to take this into account
  • User must specify a full path the first time a script is run using the "@" directive (eg @c:\mydir\myfile.sql). After that, the path becomes the working directory and no path is required (eg @myfile.sql).
  • Scripts can be nested. For example myfile.sql can contain a line that reads "@myotherfile.sql".
  • If .SQL extension is omitted from a file name, it is assumed.

Kno wn Issues


Visual Studio .NET XML Schema  Designer
Dragging and dropping objects from the Oracle Explorer into the XML Schema Designer requires the Microsoft OLEDB Driver for Oracle.

Running a Stored Procedure or Function

  • Running a stored procedure or function that returns a null value for an out parameter of sys_refcursor data type   is not supported.

OracleDataAdapter Wizard

  • In the OracleDataAdapter wizard, previewing results for stored procedures or sql statements with IN or IN-OUT parameters is not supported.


  • The "Apply Filters" settings revert to default values if "Data Source Name", "User Name", or "Role" properties are modified.
  • If "Display public synonym" checkbox is checked *all* types of public objects will be visible.

Oracle Query Window
  • UDT output is not supported
  • SQL statements which are blocked due to row locking cannot be canceled.
  • Variable binding is not supported
  • Users should not try do a dbms_output.put_line more than 1024 times in a PL/SQL block.


"This product includes software developed by the University of California, Berkeley and its contributors."