ZF-8597: We have a Zend_Db_Statement_Oracle_Exception: 972 ORA-00972: identifier is too long, when its not the case.

Issue Type: Bug Created: 2009-12-21T12:26:26.000+0000 Last Updated: 2010-02-19T14:36:58.000+0000 Status: Resolved Fix version(s): - 1.11.0 (02/Nov/10)

Reporter: Pierre LeBlanc ( Assignee: Mickael Perraud (mikaelkael) Tags: - Zend_Db_Adapter_Oracle

Related issues: Attachments:


The maximum length of a table field name in Oracle is 30 characters long, but we have a "Zend_Db_Statement_Oracle_Exception: 972 ORA-00972: identifier is too long" error message when we do an insert or update on a table with fields name of 28, 29 or 30 characters long because in the update and insert functions in the Zend_Db_Adapter_Abstract class, a colon ":" and an integer "$i" are added to the "$col" name to get a new key for the "$bind" array.


Posted by Mickael Perraud (mikaelkael) on 2010-02-19T14:36:57.000+0000

Fixed with r21108 in trunk

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.