Package omitted when reverse engineering an Oracle database in Visio (290889)
The information in this article applies to:
- Microsoft Visio 2002 Professional
- Microsoft Office Visio Professional 2003
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 Visio 2002 or in Visio 2003, the Oracle packages contained within a stored procedure are omitted.
CAUSE
Microsoft Visio 2002 and Visio 2003 cannot display packages stored within an Oracle database.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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.
| Modification Type: | Major | Last Reviewed: | 10/13/2006 |
|---|
| Keywords: | kbpending kbprb KB290889 |
|---|
|