rev. code engin.: read packages from database

[Mabel]

Hai all,

I am trying to reverse engineer our oracle database.
we have several schemes, which interact with each other.
Within the schemes, most of the interactions between tables are controlled by  packages, i.e. collections of procedures with specification and body.

I can import tables and procedure, but EA does not see the packages. How can I get the packages (preferredly with the interdependencies of the procedures) imported?

It would be extemely nice to get them in....

Thanks,
Markus

[«Midnight»]

Markus,

There's not much on this so far, but take a look at these threads:
http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=Automation;action=display;num=1133465934;start=1#1
Particularly near the end,
and
http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=general;action=display;num=1132750161;start=3#3
Note that much of this relates to EA 6.0; perhaps 6.1 goes further than just the root package.

You may have to build an add-in, or some kind of preprocessor, or whatever.

David

[Mabel]

Thanks David!

I will try to work out something for the packages. Indeed what we need the packages for suits more
a state machine view or an interaction view.

In any case, I need to get out the information
of the oracle DB, where it is stored.

Best,
Markus

[«Midnight»]

Unfortunately that's where all the hard work, and possible and potential pitfalls, will be found.

Once (if) you can get the information into EA you can get it to where you want - possibly with the aid of an add-in or something.

You may be faced down the line with issues relating to delivering the procedures (with or without Oracle packages) back into a database, but I think there are other options for that.

Oracle seems of late to be producing more tools, or at least richer feature sets, for developers. They've continued their work in the Java world, and some really nifty stuff is coming out for .Net integration - particularly in the 10g world. This could ease some of your downstream workload.

I don't (yet) have a feel for whether these tools could help here. A possibility would be something that could expose Oracle Package structure and internals to (say) Visual Studio (or perhaps one of the Java development environments, perhaps Eclipse). Then perhaps you could somehow grab the information with EA through one of the MDG links. Some unknowns here, and definitely some work involved even in the best case... Who knows?

David