PRB: Oracle Database Projects Do Not Show Package Information

• 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