Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: pl_sql_usr on December 01, 2005, 11:38:53 am

Title: PL/SQL language Support
Post by: pl_sql_usr on December 01, 2005, 11:38:53 am

Hi,

Has anyone used PL/SQL as a Language in EA? If so could you please share information on how to customize EA to get Code generated from EA.

Your suggestion is highly appreciated.

Thanks in advance!
VK

Title: Re: PL/SQL language Support
Post by: Bruno.Cossi on December 01, 2005, 04:58:08 pm

Hi,

as PL/SQL is not quite object oriented, it does not lend itself very well to code engineering. Having said that, we do reverse engineer Oracle databases including PL/SQL code as long as it is stored within the database.
We have experimented with mapping EA Classes to PL/SQL Packages and methods to functions/procedures, but found it of a limited value.
What exactly are you looking to do?

Bruno

Quote

Hi,

Has anyone used PL/SQL as a Language in EA? If so could you please share information on how to customize EA to get Code generated from EA.

Your suggestion is highly appreciated.

Thanks in advance!
VK

Title: Re: PL/SQL language Support
Post by: pl_sql_usr on December 02, 2005, 11:23:59 am

Bruno,

Thanks for the response.

I agree that PL/SQL is not a complete OOP language. We have requirement to use PL/SQL to develop the Project.

Great that it is already been experimented. I think as of now we need the information of how to convert the classes to packages and functions. Would you be able to share the information for us. And also the the reverse engineering of PL/SQL thing.

As my profile says, I'm a really a newBie, learning to how to use EA too.

Thanks!
VK.

Title: Re: PL/SQL language Support
Post by: Bruno.Cossi on December 05, 2005, 06:33:43 am

Hi VK,

I will see if I can publish the PL/SQL templates, we have created them as part of a commercial project so I will have to check whether I can make them publicly available - I do not think it will be a problem.
The approach we have taken was to create a UML package for each database schema, within the package a class stereotyped as <<plsql package>> for each database package, each method of the class would be translated to a function within the package.
As far as reverse engineering goes, we have written our own product that reverse engineers Oracle database including the code. I would be happy to discuss this in more detail, please feel free to contact me by e-mail (see my profile for the address).

Thank you,
Bruno

Title: Re: PL/SQL language Support
Post by: Bruno.Cossi on January 10, 2006, 04:49:57 pm

Please see it on EA User Group site here:

http://sharepoint.eausergroup.org/plsql

Bruno