PRB: Oracle Database Projects Do Not Show Package Information (196350)


The information in this article applies to:

  • Microsoft Visual Studio, Enterprise Edition 6.0
This article was previously published under Q196350

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.
Modification Type:MajorLast Reviewed:10/2/2003
Keywords:kbOracle kbprb KB196350
©2003 Microsoft Corporation. All rights reserved.