Modelling Oracle Stored Procedures

[Darren Lock]

What is the correct way to model a package of stored procedures and more importantly how to do this to ensure the DDL generator to creates the necessary DDL?

[hd]

Stored procedures are currently only generated when attached to a table.
However, you can add stored procedures to a package with the following steps...

1. Add a table(s) to a package, and select a target database.
2. Add an operation and give it the name of the stored procedure.
3. Select 'proc' from the stereotype combo.
4. Put the body of the procedure in the Notes section of the dialog. Save.
5. Right click on the package and select Code Engineering->Generate DDL.
6. Check 'Create Primary/Foreign Key Constraints' and 'Generate Stored Procedures'.
7. Generate the procedures.

Hope this helps.