Stored procedures in Oracle Packages

[fhaszler]

Has anyone succeeded to reverse stored procedures placed in packages for Oracle 10g.

Reversing the database I get only those stored in the main/root package. I use EA 6.0 Enterprise.

Thanks in advance,
Florin

[sobedi]

yeah

i wrote a custom script for exporting the package structure in XML
transformed it in XMI
and then reimported it in EA...

There are no build-in features for this...

This also applies for other database structures like views, sequences, etc...

[fhaszler]

Great, that is a good idea. Too bad I have no time/resources to implement it, too.

Too bad this is not an implemented feature of EA, because, not only the reverse engineering/import is important, but also generating these entities.

Thank you for you reply  

[Gary W.]

fhaszler,

Assume sobedi was talking about dbms_metadata, an Oracle 10g built-in package to extract/ transform the packages, I can give you a sample script to do the same.

This, along with the on-line help should get you XMI files ready for import into your EA.  Just let me know the email address you wish me to send it to.

Gary

P.S. I don't agree that EA should have the built-in ability to r/e vendor-specific implementations of server-side code.  It would be nice, but it's not on my top 10 list of enhancements.