Apache OpenOffice (AOO) Bugzilla – Issue 19097
Oracle 8i (Release 3) error ORA-01475 when adding data through a form
Last modified: 2006-05-31 14:29:06 UTC
Hi, Auto-generated a form with OOo 1.1RC3 on Win XP, running against an Oracle 8i 8.1.7 (Release 3) database (64 bit Solaris, 64 bit version of Oracle), using the Oracle ODBC drivers. When trying to add data to the database through the form, it comes up with this error for each record: "[Oracle][ODBC][Ora]ORA-01475: must reparse cursor to change bind variable datatype" Whenever updating an existing record in the database, no errors occur... just when adding a new one. There are no referential integrity constraints nor sequences nor other external dependencies (it's a simple table), so this isn't making much sense. It's definitely stopping us being able to deploy OOo in wider circles throughout Telstra, as I'm not even able to demo it without error to the management who are interested.
correcting sub component (http://www.openoffice.org/issues/describecomponents.cgi?component=database%20access) and default owner Marc, do we have this Oracle version here in house?
Hi Justin: I have some more questions about this issue: - What structure has the table, what kind of fields (varchar, int)? - Is this the only table where the problem occur? - Can you insert records to an other table? - does the issue also occur when you using the table view in the datasource browser to add a new record? Or occur this error only in a form? Bye Marc Just for the record this is the complete error description from the Oracle doc. ORA-01475 must reparse cursor to change bind variable datatype Cause: After executing a statement, an attempt was made to rebind a bind variable with a datatype different from that of the original bind. Action: Re-parse the cursor before rebinding with a different datatype.
Hi Marc, Yep, looked up the error message in the Oracle docs already. That's why it doesn't make sense. - What structure has the table, what kind of fields (varchar, int)? - Is this the only table where the problem occur? - Can you insert records to an other table? It happens with every table that I've created thus far, mixtures of VARCHAR2, NUMBER and CLOB. No foreign keys, triggers, etc, involved. Also happens with tables that are just VARCHAR2 and NUMBER. - does the issue also occur when you using the table view in the datasource browser to add a new record? Or occur this error only in a form? Just checked, and it also happens when adding new records through the datasource browser. :( Anything more I can do to assist? Remote access to the database in question isn't possible (firewalling + security issue).
Hi Marc, Yep, looked up the error message in the Oracle docs already. That's why it doesn't make sense. - What structure has the table, what kind of fields (varchar, int)? - Is this the only table where the problem occur? - Can you insert records to an other table? It happens with every table that I've created thus far, mixtures of VARCHAR2, NUMBER and CLOB. No foreign keys, triggers, etc, involved. Also happens with tables that are just VARCHAR2 and NUMBER. - does the issue also occur when you using the table view in the datasource browser to add a new record? Or occur this error only in a form? Just checked, and it also happens when adding new records through the datasource browser. :( Anything more I can do to assist? Remote access to the database in question isn't possible (firewalling + security issue). As a thought, just noticed that 1.1RC4 is on the official FTP mirror sites, but not publicly announced. Just downloaded it and installed it. Same problem. :( The error message that OOo gives when this message occurs (from clicking the "More" button) is below. This is all from RC4 now. Information *********** Error inserting the new record Error ***** SQL Status : HY000 Error code : 1475 Is that useful? Regards and best wishes, Justin Clift
change subcomponent to 'none'
hi, I can reproduce this, when I turn off the "Enable Closing Cursors" option in the Oracle ODBC driver. So please turn on the "Enable Closing Cursors" option in your ODBC driver and then you should be able to insert new records. I set this issue as worksforme and close it. feel free to reopen it if this solution doesn't work. Bye Marc
close