Oracle database package Reverse Engineering

[sekhar_aripaka]

Hi, we were trying to Reverse Engineering oracle database packages into EA for documentation purpose. Unfortunately EA is not getting the stored procs within the package. All it does is getting the package code into the body element.

We need all the stored procs(within package) to be imported into the data model as individual elements, so that we can use them in sequence diagrams and generate documentation. We tried several available options in ver 7.5; I believe this is not supported by EA.

Any help in this is highly appreciated!!

[NickH]

Hello, I have exactly the same problem. When I reverse engineer Oracle packages it only imports two operations:
- One called "body"
- One called "specification"
This is not useful at all other than for getting the name of the package into EA. Do i have to go and add all the procedure names in manually? It seems like a bug or a missing feature.

[k2901]

I have the same problem. I've tried Oracle Client 10g and 9i client, still no difference. I notice that the datastore connection, when using EA in a corporate env, uses the OLEDB driver. Anyone used this and what results did you get?

[k2901]

I've now raised this as a bug with Sparx. No response as of yet. Anyone got any further help/advice would be appreciated.

One avenue of thought is the permissions on the Oracle user id access the Oracle database. Does anyone know what permissions it should have when its being used by the EA software?

[k2901]

Sparx have confirmed that reverse enginnering ODBC schema with Oracle packages will only load the body and spec elements. Individual procedures/functions of a package are not reversed into calsses/operations - this is by design. I have asked for this to be raised as a new "feature request".

So the only way to get a stored procedure reversed using the ODBC connection is to have the stored procedure/function outside of a package in Oracle! Not sure if this is the same when using SQL Server, anyone know?