Messages

1

Bugs and Issues / Reverse Engineer WMS (Oracle database) - Database builder (EA 14.1)

« on: September 22, 2022, 10:17:29 pm »

Hi I'm using the database builder in EA 14.1 to synchronize WMS (oracle database) information for reverse engineering purposes.

After installing 'Oracle in OraClient12Home1_32bit' and configuring Oracle client on my laptop, I'm able to make a connection to the database with the database builder.
I can select elements from the database to synchronize with EA.

I only face problems with synchronizing the Oracle Packages.
In EA, after changing the Stereotype in Class, i'm able to see the code in the Operation code field (body, specification). Although the actual code in the oracle database for most of the packages is long. I see that in the synchronisation process with Enterprise Architect, only the first max 32 kb on a code field is synchronized.
In EA the code field can exceed this, so this limit isn't in the EA field.

With a half synchronization this ain't usefull and also not maintainable.
Is there somebody how can point me in the right direction ?

I already tried the same thing with EA 16 trial version. I noticed that the Oracle Package 'attributes' (body, specification) didn't show up after synchronizing the oracle packages. So I wasn't able to do further investigation on that.

Kind regards.

2

Automation Interface, Add-Ins and Tools / Re: Detailed instructions to reverse engineer old Oracle 9i database

« on: September 22, 2022, 09:53:02 pm »

Hi,

I succeeded in building a connection with the EA data base builder (EA 14) with Oracle DB.
I installed the 'Oracle in OraClient12Home1_32bit'
The tables and packages can be synchronised now.
 I only have a problem with the size of the package body and package specifications, which in the reverse engineering process have a max cap on 32 kb (will create another topic on this forum for this).

Kind regards,

 

3

Bugs and Issues / EA 14 Reverse Engineered Oracle database package creates class with Type Package

« on: May 19, 2022, 07:50:18 pm »

In EA 14 I reversed engineered Oracle Packages from an Oracle database.
EA creates a class object, with both stereotype and type 'package' with two stereotypes operations:
<package body> body()
<package specfication> specification()

Both operations aren't visible in the feature window under Operations.
When selecting one of these operations, no Operation Properties window is shown.
Only an empty and grayed out Propertie window is shown.

In an usual 'Operation Properties window' the tap Code is available.
After searching the EA help, this is the position where the database code for packages will be placed.

Though, when I run the following SQL statement in EA:

SELECT *
FROM t_object el, t_operation op
WHERE el.Name = 'Testblok'
AND el.Object_ID = op.Object_ID

I can retrieve the information for both the body and the specification in the search window.

After changing the stereotype to "_package" and the type to object and than to class again the operations are available with the Operation Properties window.


BUG - EA 14 Reverse Engineered Oracle database package creates class with Type Package.

4

Suggestions and Requests / Re: oracle package documentation

« on: May 19, 2022, 05:46:44 pm »

For procedures and functions it is possible to right click the element and click "SQL Object Properties".
In this screen I can view the code.

I'm struggling with opening the Oracle Package code.
Reverse engineering the package gives the result in EA of a Class with two operations:
<package body> body()
<package spec> specification()
I read that the code would be written in the operation code section.
But in EA 14 i'm unable to open these specific operations, to get to the code section.
When I manually create an operation, I'm able to get to this view.

Could someone tell me to retrieve the reversed engineered Oracle package body and specification code ?
Kind regards