Microsoft KB Archive/290889

= Package omitted when reverse engineering an Oracle database in Visio =

Article ID: 290889

Article Last Modified on 11/28/2006

-

APPLIES TO


 * Microsoft Office Visio Professional 2007
 * Microsoft Office Visio Standard 2007
 * Microsoft Office Visio Professional 2003
 * Microsoft Office Visio Standard 2003
 * Microsoft Visio 2002 Professional Edition

-



This article was previously published under Q290889



SYMPTOMS
When you try to reverse engineer an Oracle database by using the Database Model Diagram solution in Microsoft Office Visio, the Oracle packages contained within a stored procedure are omitted.



CAUSE
Visio cannot display packages stored within an Oracle database.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
An Oracle package is a collection of related program objects stored per schema in a database. Packages can comprise procedures, functions, variables, constants, cursors, and exceptions. Usually, they are used by a database administrator to allow greater control over application development. This is because the packages allow the overloading of functions and procedures, multiple readings of package objects into memory, and modification of code without recompiling dependent schema objects.

Additional query words: VSO2007 VSO 2003 vso2002 db VSO2003 VSO2002

Keywords: kbpending kbprb KB290889

-

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

© Microsoft Corporation. All rights reserved.