Book a Demo

Author Topic: Stored Procedures in EA  (Read 3204 times)

ChristoLinde

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Stored Procedures in EA
« on: May 15, 2003, 04:27:04 am »
Can anybody tell me how do I create a stored procedure in EA?  There is an option to generate stored procedures but I do not know how to enter one in EA.


Thanks
Christo

gtschech

  • EA Novice
  • *
  • Posts: 14
  • Karma: +0/-0
    • View Profile
Re: Stored Procedures in EA
« Reply #1 on: May 22, 2003, 12:20:18 am »
I second this motion...

I really like the possibility of reverse (and forward) engineering databases, but I am missing the stored procedures part in it.
We are using the EA for a Web project that interacts with the (MS SQL Server) database only by means of stored procedures, so it is critical to have them in the model.
My current workaround is a class 'StoredProcedures' where I can enter the stored procedures as operations and link them manually to the tables the use (typically, there's a many-to-many relation between SPs and tables).

I'd like to have som means of putting those procedures inside the database and pulling them out again (at least to have the documentation inside my SPs and get the parameters back into the model).