Cathy,
Please do not use the Oracle8 add-in together with the Data Modeler add-in. Stored Procedures are part of the Data Modeler. Probably you have defined everything in the Data Modeler (at least I can not see any notification that you used the Oracle8 add-in), but you are reading the Oracle8 add-in version number. Boolean is not a standard data type of Oracle8 database. If you define a stored procedure in Rose, only standard data types are accepted. Use a char(1) for Boolean values - it is shorter than any number. Regards, Davor Gornik -----Original Message----- From: Visser, Cathi (EARN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 9:16 AM To: [EMAIL PROTECTED] Subject: (ROSE) Stored Procedures with Boolean Parameters I'm trying to put a pl/sql stored procedure into my Oracle data model. It works great until I get to the Boolean parameter. Boolean is not one of the items that I can choose on the drop down list. What is the best work around for this? Do I need to use numbers or characters I'm using Rose Enterprise Edition 2001. The Oracle 8 says version 2.1 in the About Window. Thanks Cathi [EMAIL PROTECTED] ************************************************************************ * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Admin.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 * ************************************************************************* ************************************************************************ * Rose Forum is a public venue for ideas and discussions. * For technical support, visit http://www.rational.com/support * * Admin.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 * *************************************************************************
