Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Suyash Apte on March 29, 2010, 08:45:24 pm

Title: Importing Stored Procedures inside Packages
Post by: Suyash Apte on March 29, 2010, 08:45:24 pm

I have database where multiple stored procedures are within a oracle database package. When using database engineering, these Stored Procedures are not shown as individual methods, but whole package is shown as a method. How do i get each stored proceed modeled as independent method with database package modeled as class.

Title: Re: Importing Stored Procedures inside Packages
Post by: hzapata19 on April 28, 2010, 11:31:26 pm

I have the same problem, How can I do that?
If you know how, please, tell me.

Title: Re: Importing Stored Procedures inside Packages
Post by: Paolo F Cantoni on April 29, 2010, 12:19:05 am

What settings did you select in the "Import DB Schema from ODBC Source" dialog?

Paolo

Title: Re: Importing Stored Procedures inside Packages
Post by: hzapata19 on April 29, 2010, 08:29:26 am

Hi Paolo:

This is the information:

Oracle database 10g Enterprise Edition 10.2.0.40 - 64 bits
Driver:  Oracle ODBC Driver 11.1

I'm trying to import an oracle package with 4 procedures inside.

I selected this options in the Import DB Schema from ODBC source:
- Include User Packages
- Include User Stored Procedures ...
   - Import as individual classes

-Include User Functions ...
   - Import as individual classes

- Import as New objects
-Diagram & Package


When the import process ends the diagram only shows a class with the stereotype "Package" and the name of package and two public operations: spectification() and body() with the stereotype "package spectification" and "package body".

I can't see procedures and function inside de package as operation nof the class.

Please. Can you help me how can I get that.

Thanks