How to create stored proc interaction diagram using Enterprise Architect
I am analyzing complex stored procedures written for legacy application. In order to understand the flow of calls between stored procs and functions for a given functionality, I would like to create a diagram (similar to Sequence Diagram) using Enterprise Architect.
Does anyone knows what type of diagram is most suitable as I am unable to find the right fit.
I tried Design>Model Patterns>Database>Oracle but cant find shapes to represent interaction between stored procs.
When you turn on the DatabaseEngineering MDG you can create a table. There you find constraints as analogy to operations. Once you open them you can define triggers
To show the dynamic part it's best to use a sequence diagram showing triggers and execution of stored procedures as messages.
- Why my query to select from Oracle database turn to text (blank query) every time i run it
- Oracle ORA-00902 Invalid datatype error
- Check if Advanced Compression is available
- Strange full table scan statements in Oracle
- Options to enforce a logical constraint in an Oracle database
- How to sort numbers before letters with linguistic sorting?
- How to sort all numbers before letters with linguistic sorting?
- Oracle Trigger Creation Error: PLS-00049 BAD BIND VARIABLE 'OLD'
- plsql script is raising 'ERROR at line 1 DECLARE', I don't see the reason
- Update table column based on join in Oracle
- Oracle Apex - Download CSV produces an empty report
- SSIS - the value cannot be converted because of a potential loss of data
- Filtering duplicate values, searching for pairs
- Trying to filter a sql report by a range of numbers
- Adding html target attribute to APEX tree link
- Date function not returning expected Month
- Extract specific value from CLOB (containing XML) while creating one delimited string per row of a table. CLOB value may be null on some rows
- Is java.sql.Timestamp timezone specific?
- SQL pivot and sum total
- Inserting current date and time to Oracle database using Java
- Queue monitoring oracle script
- Date Time Format, Perl Oracle SQL
- Performance tuning of Update statement in ORACLE
- Ansible playbook takes forever to execute an Oracle DB query
- Search All Fields In All Tables For A Specific Value (Oracle)
- Get 12 month running total for subgroups in Oracle
- Returning clause in json_table or skip error on error?
- Find a gap > 10min and select begin/end dates in timestamp logs
- Need to extract value from key-value pair data
- How to "join" 2 functions in Oracle SQL where the result from one function is a param to another