I am getting this when running the install script. All packages, functions and procedures that have been created are invalid. Attached is the TDI schema as seen in SQL Developer.

SQLSTATE[HY000]: General error: 6575 OCIStmtExecute: ORA-06575: Package or function IDENTIFIER is in an invalid state (ext\pdo_oci\oci_statement.c:148)

CommentFileSizeAuthor
Drupal-Oracle-Install.png52.31 KBSERVANT14

Comments

reinaldoc’s picture

reinaldoc commented

I'm exactly with the same problem on Oracle 11.2, did you solve them?

reinaldoc’s picture

reinaldoc commented

The problem was solved grant correct permissions.

# sqlplus SYSTEM

SQL> create tablespace drupal
2  logging
3  datafile '/u01/app/oracle/oradata/drupal.dbf'
4  size 32m
5  autoextend on
6  next 32m maxsize 3072m
7  extent management local;

SQL> create user drupal identified by password (where password is user password)
2  default tablespace drupal
3  temporary tablespace temp;

SQL> grant unlimited tablespace to drupal;
SQL> conn sys/password as sysdba (password replace with password of user SYSTEM)
SQL> grant execute on dbms_crypto to drupal;
SQL> grant select on v_$sql_plan to drupal;
SQL> grant select on v_$sqlarea to drupal;
SQL> grant connect to drupal;
SQL> grant resource to drupal;
bohart’s picture

bohart
Location Lutsk, Ukraine
commented
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.