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:
http://www.oracle.com/technology/tech/dotnet/tools/index.html
Release 10.1.0.4
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
- Visual Studio .NET 2003
(any version: e.g.
standard/professional/enterprise)
- Access to an
Oracle10g/9.2.x/9.0.x/8.1.7.4.1 database
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!
http://forums.oracle.com/forums/forum.jsp?forum=228
General
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
10.1.0.4
- Oracle Data Provider for .NET -
version 10.1.0.4
- Oracle Client – version 10.1.0.2
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.
Known 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.
Filters
- 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.
Acknowledgements
"This product includes software
developed by the University of California, Berkeley and its
contributors."
Bookmark
