Re: Import Designer 2000 Web PLSQLs into Designer 9i

[Quoted] Frank van Bortel wrote:
> Jason King wrote:
>

>
>
> Nonsense, you can reverse engineer any PL/SQL in designer....
>
> It's just a pity you will not have any relations, code reusability,
> etc, what could have been inside the previous repository.
> Don't you have a backup, or application export lying around
> somewhere?
> Would be a tremendous help.
>
> If not - you're faced with the problem of distinguishing
> Designer added (transactional/referential) code from the actual
> application code.
> Not a nice task, as one of the long standing
> bugs has been the size of Designer generated packages and procedures
> being too large for SQLplus to execute...

[Quoted] Assuming we have mod$ mod$comp and mod$js$comp for a simple one-component web pl/sql module you can indeed reverse engineer the 3 packages back, but they're just pl/sql code. There is no automated way to turn them back into a designer module and module component and use Designer to change, say, query criteria and regenerate. I believe that was the OPs question.
For Developer modules I gather there is some ability to reverse engineer them back into modules, but as I've never worked on Developer modules I don't know how well that works. Received on Tue Jun 22 2004 - 18:18:31 CEST