As an erstwhile Oracle Designer user, I was a bit dismayed to find that the Rose Data Modeler does NOT allow you to reference a table column or a domain for a stored procedure parameter's datatype.
Have I missed something? Is this true? Stored procedures often take parameters that need the same type as particular database columns (e.g. for doing lookups). Being able to link a parameter's datatype to a domain or, better still, a table column, boosts productivity and provides traceability between database tables and stored procedures. This would be especially handy when generating stored procs to Oracle, as Oracle allows you to anchor parameter/variable datatypes to columns (using table.column%TYPE notation). With other platforms, it's a simple enough thing to grab the column's or domain's datatype and substitute in the generation script. Any thoughts, tips, suggestions appreciated. H. John C. Hopkins Coordinator, Computer Applications Department of Pathology, Immunology, and Laboratory Medicine Box 100275 Gainesville, FL 32610-0275 (352) 265-0680 x85685 ************************************************************************ * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Post or Reply to: [EMAIL PROTECTED] * Subscription Requests: [EMAIL PROTECTED] * Archive of messages: * http://www.rational.com/support/usergroups/rose/rose_forum.jsp * Other Requests: [EMAIL PROTECTED] * * To unsubscribe from the list, please send email * To: [EMAIL PROTECTED] * Subject: <BLANK> * Body: unsubscribe rose_forum *************************************************************************
