To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=83361 Issue #|83361 Summary|Oracle tables with foreign keys are not accessible Component|Database access Version|OOo 2.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|cianoz
------- Additional comments from [EMAIL PROTECTED] Tue Nov 6 09:16:37 +0000 2007 ------- I created a table in an Oracle DB (not with Base) with some fields defined with an external key (foreign key). Once created this table is not accessible with base. Trying to open it I get an error message: Cannot load contents [MERANT] [ODBC Oracle Driver] Data type for parameter 1 has changed since first SQLExecute call After a long wait you can open the table, but only in read-only mode. Other tables which haven't any foreign key are accessible normally and are usable. Note: The Merant ODBC Drives in use (v3.70) is absolutely working and has no bugs as far as I know; it is the driver used for our ERP software. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]