Microsoft KB Archive/196350

= PRB: Oracle Database Projects Do Not Show Package Information =

Article ID: 196350

Article Last Modified on 10/2/2003

-

APPLIES TO


 * Microsoft Visual Studio 6.0 Enterprise Edition

-



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.

Keywords: kboracle kbprb KB196350

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.