Book a Demo

Author Topic: Importing Stored Procedures inside Packages  (Read 3578 times)

Suyash Apte

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Importing Stored Procedures inside Packages
« 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.


hzapata19

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Importing Stored Procedures inside Packages
« Reply #1 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.

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +257/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Importing Stored Procedures inside Packages
« Reply #2 on: April 29, 2010, 12:19:05 am »
What settings did you select in the "Import DB Schema from ODBC Source" dialog?

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

hzapata19

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: Importing Stored Procedures inside Packages
« Reply #3 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