ORA-24508 when calling SQLExecDirect on "SELECT 1"
Hello all,
Application uses Oracle Client to remotely access to Oracle DB Server ...
Our application calls SQLExecDirect to execute the statement "SELECT 1 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ?".
The call is to check if the tablespace exists on a list of tables. For example, tableA, tableB, tableC, tableD, tableE,...
The SQLExecDirect returns the error ORA-24508 on every other table (i.e. tableA, tableC, tableE, ...)
DB Error: ORA-24508: Buffer is not aligned correctly. -- SQLSTATE=, SQLCODE=24508
Here are the Oracle server and client levels:
Application uses Oracle Client to remotely access to Oracle DB Server ...
Our application calls SQLExecDirect to execute the statement "SELECT 1 FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = ?".
The call is to check if the tablespace exists on a list of tables. For example, tableA, tableB, tableC, tableD, tableE,...
The SQLExecDirect returns the error ORA-24508 on every other table (i.e. tableA, tableC, tableE, ...)
DB Error: ORA-24508: Buffer is not aligned correctly. -- SQLSTATE=, SQLCODE=24508
Here are the Oracle server and client levels:
- Linux SUSE: Server Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_TERRITORY AMERICA
0