Stored Procedure DDL Generation

[Don Miller]

 
Greetings All:

I've read (most) of the available information in the BB's here about modeling SQL Stored Procedures, how to represent result sets as classes with a <<table>> stereotype and so forth.

The bit I don't get yet is: can EA 3.50 (579) generate stored procedure script? When I create an operation on a <<table>> class and set the operation stereotype to <<proc>> I get the header in my DDL script, and the Notes are added too, but that's the only field that seems to make it into the script. I'm supposing that there's somewhere that I can actually type the procedure script so that it too is included in the output.

So I guess the question is, where does one enter stored procedure script (INSERT blah INTO blah blah) in EA so that it gets generated to the DDL output?


Thanks!
Don

[ianrobinson]

Does anyone know the answer to this, i also have been battling to make it work.

[Peter_Cheung]

I don't think EA support coding within the model and have it include part of the code generation.  

If someone have a solution on this, I would like to know as well.

Thanks

[CJ]

G'day folks,

Haven't tried either of these, but I'd think both should work...

You could use EA automation and a custom PL/SQL generator to access whatever objects contain PL/SQL and produce PL/SQL scripts.

Another option would be to query the EA project file with ODBC, querying for those objects that contain your PL/SQL, and using SQL to build your PL/SQL DDL statements.