>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #1096602. --> Reported by: [jm.federico](https://www.drupal.org/user/509892) >>> <p>Hello</p> <p>Having issues with Oracle on D7.</p> <p>I can install Drupal, no problem there, but I can't add fields to content types.</p> <p>Steps:</p> <p>1. Code to "Manage Fields" for Article<br> 2. Add an image field<br> 3. Click on "Save field settings"<br> 4. Click on "Save"<br> By now you should see an error like this:</p> <pre>PDOException: DROP TABLE {field_revision_field_myimagefield} CASCADE CONSTRAINTS (prepared: DROP TABLE "FIELD_REVISION_FIELD_MYIMAGEFIELD" CASCADE CONSTRAINTS ) e: SQLSTATE[01002]: Disconnect error: 604 OCIStmtExecute: ORA-00604: error occurred at recursive SQL level 1 ORA-02264: name already used by an existing constraint (/PDO_OCI-1.0/oci_statement.c:142) args: Array ( ) in db_drop_table() (line 2687 of /var/www/drupal/includes/database/database.inc).</pre><p>or something like this</p> <pre>PDOException: DROP TABLE {L#326} CASCADE CONSTRAINTS (prepared: DROP TABLE "L#326" CASCADE CONSTRAINTS ) e: SQLSTATE[01002]: Disconnect error: 604 OCIStmtExecute: ORA-00604: error occurred at recursive SQL level 1 ORA-02264: name already used by an existing constraint (/PDO_OCI-1.0/oci_statement.c:142) args: Array ( ) in db_drop_table() (line 2687 of /var/www/drupal/includes/database/database.inc).</pre><p>If you didn't get the error proceed to "edit" the field. It throws an error like this:</p> <pre>PDOException: SELECT COUNT(*) AS expression FROM (SELECT * FROM (SELECT TAB.*, ROWNUM RWN_TO_REMOVE FROM (SELECT 1 AS expression FROM {field_data_field_dsfsdfwe} field_data_field_dsfsdfwe0 WHERE (field_data_field_dsfsdfwe0.deleted = :db_condition_placeholder_0) ) TAB) WHERE RWN_TO_REMOVE BETWEEN 1 AND 1) subquery (prepared: SELECT COUNT(*) AS expression FROM (SELECT * FROM (SELECT TAB.*, ROWNUM RWN_TO_REMOVE FROM (SELECT 1 AS expression FROM "FIELD_DATA_FIELD_DSFSDFWE" field_data_field_dsfsdfwe0 WHERE (field_data_field_dsfsdfwe0.deleted = :db_condition_placeholder_0) ) TAB) WHERE RWN_TO_REMOVE BETWEEN 1 AND 1) subquery ) e: SQLSTATE[HY000]: General error: 942 OCIStmtExecute: ORA-00942: table or view does not exist (/PDO_OCI-1.0/oci_statement.c:142) args: Array ( [:db_condition_placeholder_0] =&gt; 0 ) in field_sql_storage_field_storage_query() (line 569 of /var/www/drupal/modules/field/modules/field_sql_storage/field_sql_storage.module).</pre><p>it seems to be erratic, it sometimes lets me create fields, some others won't.</p> <p>Help would be appreciated. I have no experience with Oracle, I wouldn't know where to start looking for the problem.</p> <p>Marking as critical since it breaks functionality of Drupal.</p>