PL SQL package reverse engineering

[MastaKilla]

Hello,
We are using EA as a metadata and model repository for large Oracle project. We do use reverse engineering and code generation on everyday basis.

Is there a solution (add-in, template) to reverse engineer PLSQL package to the point of having its real functions and procedures represented under package as operations?

Currently EA provides reverse of PLSQL package as

Package: Package name
Package operations:
<<package spec>>specification() operation as for package speciffication
and
<<package body>>body()

where whole code for each part is stored in Behavior:Initial Code.

We are looking for soultion to reverse package into a following representation. For example:

Package:Package name
Package operations:
<<function>> Function_1(int)
<<function>> Function_2(int)
<<procedure>>Procedure_1

I would strongly appreciate  any help with this.
Thanks
Ivan

[rsipin]

I would strongly agree. We manage nearly 100 different systems, and the only languages which we cannot use EA for is our database embedded code. It's not a trivial matter by any means to keep Packages and Operations in synch by hand with large database systems.

[mbald]

We would appreciate some news or support regarding this topic as well.

It would be perfect to be able to import procedures/functions of PL/SQL packages as operations of a class (with stereotype <<package>>).

Like this the operations could be reused within the entire model. E.g. in sequence diagrams.

Thanks,

Michael

[RoyC]

Perhaps you could submit this as a feature request to Sparx Support, using the link in the Support column at the foot of this page.