When performing a clean install of Drupal 7.15 and the latest released Oracle Driver 1.12, I get the following error following the database connection step of install.

SQLSTATE[HY000]: General error: 904 OCIStmtExecute: ORA-00904: "IDENTIFIER"."GET_SERIAL": invalid identifier (/home/dwelborn/oci/BUILD/PDO_OCI-1.0/oci_statement.c:142)

Comments

tparks’s picture

tparks commented

Looking in the DB, there are some tables that have been created:
- BIND_TEST
- BLOB_COLUMN
- BLOBS
- LONG_IDENTIFIERS
- ORACLE_BIND_SIZE
- USED_BLOBS
- VARIABLE

carincon’s picture

carincon commented

I have the same error, you see
/yousite/includes/database/oracle/schema.inc
go to the line 121

this happends create table variable or create trigger asociated to table variable.

do you have any solution????

aaaristo’s picture

aaaristo commented
Status: Active » Closed (works as designed)

just tried a clean install with drupal 7.23 and oracle 1.12 and all works fine for me... be sure to grant the right permissions, check your logs for errors for some reason the installer was not able to create the identifier package, you will find a lot of peoples that askedthis question on the issue queue....