PRB: Oracle Database Projects Do Not Show Package Information

ID: Q196350


The information in this article applies to:
  • Microsoft Visual Studio, Enterprise Edition 6.0


SYMPTOMS

When you view the contents of an Oracle database in Visual Studio 6.0, the contents of packages are not displayed. However, you can view and edit procedures and functions under their associated folders.


RESOLUTION

You cannot use the Data View window to look at the functions or procedures inside of packages for an Oracle data source.


STATUS

This behavior is by design.


MORE INFORMATION

Visual Studio 5.0 includes a tab for Subprograms where all the functions and stored procedures are listed. The packages of procedures are included in this list. By clicking the package, you can see the functions and return types in the package.

Visual Studio 6.0 provides separate folders for procedures and functions, but package information is not listed in either folder or anywhere else in the project.

Steps to Reproduce Behavior

  1. Create a database project in Visual Studio 6.0.


  2. Assign an Oracle Data Source.


  3. In the Data View window there are folders for functions and procedures. Packages, or functions and procedures contained in packages, are not listed anywhere in the Data View window.


Additional query words:

Keywords : kbDatabase kbOracle kbVisDBTools kbVS600
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: April 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.