Oracle Developer Tools for Visual Studio .NET Release Notes

[심재운]

Oracle Developer Tools for Visual Studio .NET Release Notes

---

This beta release of the Oracle Developer Tools for Visual Studio .NET  now supports both Microsoft Visual Studio .NET 2003 and Visual Studio 2005. It also includes a tightly integrated PL/SQL debugger. The latest downloads, information, and community forums can be found here:  http://www.oracle.com/technology/tech/dotnet/tools/index.html

Release 10.2.0.2.10 beta

March 2006

Copyright (c) 2005, 2006, Oracle. All rights reserved.

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

• System Requirements
• Support and Product Feedback
• General Information and Dependencies
• Features not Covered by Documentation
  
• Known Issues 
• Acknowledgements

System Requirements

• Visual Studio .NET 2003  (any  version: e.g., standard/professional/enterprise) or Visual Studio 2005 (any version other than the Express Editions, which do not support add-ins).
• Access to an Oracle10g/9.2.x/9.0.x/8.1.7.4.1 database (Note: .NET stored procedure support is only included in Oracle Database version 10.2 and later on Windows)
  • Download here: http://www.oracle.com/technology/software/products/database/oracle10g/index.html  
• .NET Framework 1.1 SP1 (VS .NET 2003) or NET Framework 2.0 (VS 2005)
  

Support and Product Feedback

Oracle is very interested to hear your comments related to this beta 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.jspa?forumID=228 (Registration with OTN required)
 

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.2.0.2.10 beta (For Visual Studio .NET  2003)
• Oracle Developer Tools for Visual Studio .NET  10.2.0.2.10 beta (For Visual Studio  2005)
• Oracle Data Provider for .NET  1.0 - version 10.2.0.2.10 beta
  
• Oracle Data Provider for .NET  2.0 - version 10.2.0.2.10 beta
  
• Oracle Client  - version 10.2.0.1.0

PL/SQL Debugging not supported with Visual Studio 2005

In this beta release PL/SQL debugging is enabled with Visual Studio .NET 2003. It does not work with Visual Studio 2005.


ODT  should only be installed in one Oracle Home

ODT should only be installed in one Oracle home. If ODT is installed in multiple homes, and then one of them is subsequently deinstalled, any remaining installation of ODT will not work properly.


Using .NET Stored Procedures

If the Oracle Developer Tools for Visual Studio .NET and Oracle Database Extensions for .NET (an Oracle Database 10g database option) are installed on the same machine, you must  install and configure the latest Oracle Database Extensions for .NET beta to be able to execute  .NET stored procedures without errors. You may download the Oracle Database Extensions for .NET beta  from the same web page where you obtained this beta software.

For more information on using .NET procedures, visit the Oracle Database Extensions for .NET Tech Center at http://www.oracle.com/technology/tech/dotnet/ode/index.html

Integrated online help

If the ODT Help does not show up as part of Visual Studio .NET Help, please follow the following steps:
 

1. Start Visual Studio .NET and select ‘Search’ option from the Help menu.
2. Search for VSCC (Visual Studio Combined Help Collection).
3. Click on Visual Studio .NET Combined Help Collection Manager from the Results window.

4. Scroll down to the bottom of the page and check off the ODT Help box if it is not checked or uncheck it if it is checked.

5. Click Update VSCC button. Close and restart Visual Studio .NET
6. If you unchecked the ODT Help in step 4, repeat steps 1 to 5 to check off  ODT Help on the VSCC page.

Configuring PL/SQL debugging for first use

Please see the online help for information detailing what configuration steps are required before PL/SQL debugging is possible. This includes the following database side configurations:

• The database must be an Oracle database release 9.2 or later.
• Requirements for Oracle Database 10g Release 1 (10.1) and later:
  • The connected user must have the DEBUG CONNECT SESSION privilege to connect to a debugger, for example, GRANT DEBUG CONNECT SESSION TO HR.
  • The connected user must have the DEBUG ANY PROCEDURE privilege to debug any PL/SQL program or have DEBUG and EXECUTE privileges on the PL/SQL program being debugged, for example, GRANT DEBUG ANY PROCEDURE TO HR.
• Requirements for Oracle9i Release 2 (9.2):
  • The connected user must have the DEBUG ANY PROCEDURE privilege, for example, GRANT DEBUG ANY PROCEDURE TO HR.

For additional information on troubleshooting PL/SQL debugging problems, see "Features Not Covered By Documentation" below.

Oracle connection errors after installing Oracle Developer Tools in new Oracle home

If you start receiving Oracle connection errors immediately after installing Oracle Developer Tools, check to see if you created a new Oracle home during the install. If you did, you will need to copy over the TNSNAMES.ORA file from your old Oracle home to the new one.

ODT beta not supported with Visual Studio 2005 on Windows 2000 in 16 bit color mode

Windows 2000 users should enable 32-bit color mode if they are using Visual Studio 2005 to avoid a problem which causes Visual Studio to crash.

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.


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 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."

Localization Support

This beta version has only been certified against the English language version of Visual Studio.

Features not Covered by Documentation

PL/SQL Debugger troubleshooting

There are several scenarios where the database is not able to connect to the PL/SQL debugger:

• The connected user does not have the appropriate debug privilege to connect to the debugger. In this scenario, you will get the following message from ODT:
  • "An error occurred while executing the procedure/function:
    

                     ORA-01031: insufficient privileges
                     ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
                     ORA-06512: at line 1"

                     To solve the problem, do the following:
            
             1. Grant the "debug connect privilege" (for 10g databases) to the connected user.
             2. Grant the "debug" and "execute" privilege on the PL/SQL program to the connected user, or
             3. Grant the "debug any procedure" privilege to the connected user.

• There are no available ports for PL/SQL Debugging.

         In this scenario, you will get the following message from ODT: "Could not begin PL/SQL debugging.  There are no available ports".
         To solve the problem, you have to modify the PL/SQL Debugging Options page to add the ports for debugging.

• The debugging port is not open for external access.  This usually happens if the database connection is remote.
  

         In this scenario, you will get the following message from ODT:
            "An error occurred while executing the procedure/function:
             ORA-30683: failure establishing connection to debugger
             ORA-12535: TNS:operation timed out
             ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
             ORA-06512: at line 1"

         To solve the problem, make sure all the ports set in the PL/SQL Debugging Options page can be opened for external access.


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 (Visual Studio .NET 2003), or error list (Visual Studio 2005) will provide help for the Oracle error number
  

Oracle Query Window

• 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 necessary 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."

Known Issues

Visual Studio .NET 2002 and Visual Studio 2005 Express Editions not supported

Visual Studio 2005 Express Edition does not allow "add-ins" so it is not possible to use ODT with it.  Visual Studio .NET 2002 is not supported.

PL/SQL Debugging known issues

• In this beta release, PL/SQL debugging is not enabled for Visual Studio 2005.
• PL/SQL debugging only works for the machine user who installs ODT.  This applies to PL/SQL debugging only, and is not related to ODT in general. 
• In this beta release, the debugger does not support eval‎uation of the composite types (Object, Varray, Nested Table, Associative Array, and Record).  Please see the documentation for more details on which datatypes are supported. 
• It is not recommended that you modify any database object (perform DDL) in ODT during debugging.  If a database object is being locked by the debugger during debugging and you try to modify the database object in ODT, you might experience a hang. For example, if you are debugging SP1 and you issue a Compile Debug command on SP1 during debugging, you will see a hang in ODT. 
• A breakpoint cannot be set if there is no solution opened in VS.NET.  To set breakpoints, you must open a solution. 
• You have to "Enable Application Debugging" again to see the port number changes in the PL/SQL Debugging Options page. For example, after you set debugging port range to be 50000-50010, you  "Enable Application Debugging."  Then you change the port range to be 60000-60010.  When you start application debugging, you will see that the debugging port is within the previous port range (50000-50010). You have to "Enable Application Debugging" again to see the new port range. 
• For application and external application debugging, the Debug Location toolbar does not show the Oracle debugger process if the debugging tier is in the database tier.
  
• The OracleDebugger.exe process is not always able to terminate successfully and multiple copies may accumulate which may need to be killed manually to free up resources.  For example, when you step into a PL/SQL program that takes input parameters,  the parameter dialog will appear to allow the user to enter a parameter value.  If the user press "Cancel' at that point, debugging will stop. However, the OracleDebugger.exe process is not able to terminate.

ODT and Visual Studio 2005 known issues

• Windows 2000 users will experience crashes with Visual Studio 2005 if the OS is in 16 bit color mode. To workaround, they should enable 32 bit color mode.
• Drag and drop is not supported from Oracle Explorer to the XML Schema Designer.
  
• Project upgrade of existing Oracle Projects from Visual Studio .NET 2003 to Visual Studio 2005 does not work very well.  To do this remove the solution file (.sln), or rename it.  Then open the project file (.csproj or .vbproj) in Visual Studio 2005.
  
• In the New Project dialog, Oracle Project can be located directly under the Visual C#, or Visual Basic categories.  It cannot be located under subcategories, such as Windows, or Database.
  
• In the Deploy Options and Deploy Mapping property pages, mnemonics do not work correctly.  Typing 'c' will set the focus on the Configurations combo box, and typing 'm' will set the focus on the Platforms combo box.  As a result, 'c', and 'm' cannot be used in any of the input values in these property pages.  The workaround is to copy and paste values from another window into the property page fields.
• F1 help is not supported in deploy options and deploy mapping property pages.  Help can be located in the Oracle Developer Tools for Visual Studio .NET book, in the online help.
• When changes are made to the deploy options and deploy mapping properties, "*" does not appear next to the property page name.
• In the deploy options and deploy mapping property pages, scrolling does not work correctly.
• In the deploy options and deploy mapping property pages, using tab to move from one control to another is not supported.
• If the property designer is open, then any changes made in code to .NET stored procedures, or any changes in the Oracle Deployment Wizard for .NET, will not be reflected in the property designer. The workaround is to close the property designer, and reopen it.
• Creating a new project configuration from an existing project configuration is not supported.
• Editing properties for multiple projects at the same time is not supported.
  

User defined datatypes created after opening a connection to the database

After a connection to the database is opened using Oracle Explorer in Visual Studio .NET, if a new user defined datatype is created in the database, i.e. VARRAY, NESTED TABLE, or OBJECT,  it will not be visible to the PL/SQL wizards unless the connection node is refreshed. To achieve this, go to the connection node in Oracle Explorer, right click, and choose refresh from the menu.

PL/SQL types as parameter types for stored procedure/function/package method

Some of the PL/SQL data types (such as NATURAL or INTEGER) are aliases to database native types (for example, NUMBER). When these PL/SQL types (NATURAL, INTEGER) are used as parameter types in stored procedure or function, the PL/SQL data type displayed in the properties window for these parameters will reflect the database native type.

PL/SQL autocompletion with synonyms

In a PL/SQL editor window, synonyms nested beyond 2 levels will not expand for autocompletion.

Connecting with SYSOPER role

Connecting with SYSOPER role is not supported.

Case sensitivity and special characters in name

To preserve the case in a name for a schema object, the name needs to enclosed in double quotes. Otherwise, when the focus is moved out of the text box where the schema object name is entered the schema object name will be automatically uppercased.

Retrieving table or view data

When retrieving data from a table or view, display or editing of data for the following Oracle types are not supported:

• CLOB, BLOB, BFILE – read only
• User Defined Types, Nested Table, VARRAY – not displayed

 XMLType columns and parameters not supported with 9.0.x database

Using XMLType columns or parameters with 9.0.x database is not supported.

Table/View Designer

• Creating a non-schema based XMLType table using Table Designer is not supported.
• Committed storage parameter values appear as empty when information is not available from the database.

Running stored procedure or function

• Running a stored procedure or function that returns a null value for an output  parameter of SYS_REFCURSOR datatype  is not supported.
• Running a stored procedure or function with SYS_REFCURSOR as IN or IN-OUT parameter is not supported.
• When running a stored procedure or function, for input parameters, a <DEFAULT> value is listed in the combobox even though the procedure/function may not have a default value defined for that parameter. Selecting <DEFAULT> as the parameter value in this scenario is not supported.

OracleDataAdapter Wizard

• When the OracleDataAdapter wizard for an OracleDataAdapter component is launched more than once, the parameter information may not be populated correctly. To work around this issue, reselect the stored procedure or select statement in the wizard.
• In the OracleDataAdapter wizard, the parameter information displayed for a stored procedure is not always in sync with the stored procedure selected. To workaround this issue, select the stored procedure a few times.
• In the OracleDataAdapter wizard, previewing results for stored procedures or SQL statements with IN or IN-OUT parameters is not supported.
• In the OracleDataAdapter wizard, to auto-generate insert/update/delete statements, the SQL statement should include the primary key or a rowid in the selection list. 

Oracle Project

• The available methods in the Deploy Mapping property page are determined by the current configuration, not the configuration that is selected in the Property Pages Dialog.  Use of constants to specify which methods to include in the code should be avoided, if possible.
• The Deploy Mapping property page does not support methods with parameters of type System.Byte[].
• Automation is not supported.
• There is no Oracle-specific F1 or dynamic help for the Oracle Projects in Solution Explorer.
• If changes are applied in the Deploy Options, or Deploy Mapping property pages, and the project file is in source control, then the project must be checked out first. If the checkout operation is cancelled when prompted to checkout the project file, then the property page changes will be rolled back because changes cannot be made if the project file is not checked out. However, there will not be any message box indicating what happened.
• When the Oracle Deployment Wizard for .NET completes, and the project is in source control, then there may be a message indicating the project is being edited during a build. This warning is expected, and the edit should be allowed. Selections in the wizard need to be saved to the project file.The same problem also happens when building an Oracle Project for VB.NET after renaming the root namespace since the root namespace used for the build needs to be saved to the project file.
• Enterprise Templates are not supported with Oracle Project.

Oracle .NET Deployment Wizard

• Resizing the data grid in the Parameter Type Mapping dialog may not work as expected.
• When an assembly built in debug configuration is deployed, the associated .pdb file is not copied over to the database.
• An error may occur when copying assemblies during a deployment because Oracle Database Extensions for .NET may not unload the assemblies on the Oracle Database from a previous deployment after a .NET Stored Procedure has been executed.  If this happens, the <OracleHome>ClrAgent service needs to be stopped, the extproc.exe process killed, and the <OracleHome>ClrAgent re-started.  This affects the primary assembly being deployed, as well as the referenced assemblies.
  
• When deploying an assembly from a machine with non-English locale, the user may sometimes be prompted to enter the location of the mscorlib.resources dll. The user can either specify the new location or click Cancel and the assembly deployment will continue without any errors.

.NET Assemblies Node, and .NET Assembly Nodes

In the online documentation for .NET Assemblies Node, it says that SYS must be selected as an "available schema in Apply Filters" to be able to view the .NET Assembly Nodes.  It should say "displayed schema", not "available schema".

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.
• It is not possible to use dbms_output.put_line more than 1024 times in a PL/SQL block.

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.

Acknowledgements

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

[늘곁에]

현재 일본에서 테스트 하고 있는 사람입니다. ADO.NET2.0를 대응하고 있지만 아직 많은 부분 문제가 많은 것으로 테스트중에 발견이 되었습니다.특히 트랜잭션부분의 경우 아직 검토중입니다. 정식버전은 4월말에서 5월초에 나올 예정입니다.

[심재운]

아...그런가요.. 좋은 실무 정보 감사합니다.