The application is running well with Oracle Driver 1.12 using Oracle 10g Express /Windows Xp environment. But getting this message in the error log when deployed into linux environment.

oracle[24405]: error: SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "IDENTIFIER"."SEQUENCE_FOR_TABLE": invalid identifier
(/usr/local/downloads/php/ext/pdo_oci/oci_statement.c:148) select identifier.sequence_for_table(?,?) sequence_name from dual

In the deployment environment, web server in one linux machine and database in another linux machine. In the web server PHP 5.4 is installed using Instant Client 11.2 with pdo_oci and oci8 extension.

and in the other server oracle 10g is installed. While I can see the front page but can't login into the site. I checked the apache error log, it is flooded with above error message.

Could anyone help, how to fix it? or any hint?

thanks

Comments

shafiqhossain’s picture

shafiqhossain commented

I am using Drupal 7.14

si_odong’s picture

si_odong commented

in my experience, there were failure when installing oracle driver. they are on creating package, type, etc. in error "OCIStmtExecute: ORA-00904: "IDENTIFIER"."SEQUENCE_FOR_TABLE": invalid identifier", try to re-create type VARGS and VARGST by running .pls file on oracle/resources/type) and re-create identifier package by running oracle/resources/identifier/identifier.pls and oracle/resources/identifier/identifier.plb.

batje’s picture

batje commented

to save you 2 minutes, the .pls files are in the subfolders found in this file

/includes/database/oracle/resources/type/

bohart’s picture

bohart
Location Lutsk, Ukraine
commented
Version: 7.x-1.12 » 7.x-1.x-dev
Issue summary: View changes
Status: Active » Closed (outdated)

D7 reached its EOL back in January 2025, and there is no active release for D7 for this module anymore.
Development or support is not planned for D7. All D7-related issues are marked as outdated in a bunch.

Everyone can apply the patches/suggestions above (not tested by the maintainers, tested by the community) to their D7 projects.
If the issue remains relevant for D10+ versions, merge requests with proposed solutions for a new module version (D10+) are welcome in a new follow-up issue.

Thanks!

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.