Hi
Congratulations about Oracle drupal driver project.
I have a PDOException (0911 oracle error), when I run a sql query in my oracle external database. Any idea about this problem?
The sql query it's ok, I tested at sqlplus and works
PDOException: select gaart_cod codigo ,max(substr(replace(descrip,chr(10),' '),1,40)) descrip , round(avg(pr_precio),2) med_precio , sum(c_uni1) unid , NVL(round(sum(i_netoemp),0),0) importe , count(1) lineas ,NVL(sum( case when sysdate - f_Albaran <= 30 then c_uni1 else 0 end ),0) c_30_d ,NVL(sum( case when sysdate - f_Albaran <= 30 then i_netoemp else 0 end ),0) i_30_d ,NVL(sum( case when sysdate - f_Albaran > 30 and sysdate - f_Albaran <= 180 then c_uni1 else 0 end ),0) c_180_d ,NVL(sum( case when sysdate - f_Albaran > 30 and sysdate - f_Albaran <= 180 then i_netoemp else 0 end ),0) i_180_d ,NVL(sum( case when sysdate - f_Albaran > 180 then c_uni1 else 0 end ),0) c_mas_d ,NVL(sum( case when sysdate - f_Albaran > 180 then i_netoemp else 0 end ),0) i_mas_d from ggalblinv where ggclipr_cod = '10' group by gaart_cod order by 5 desc; (prepared: select gaart_cod codigo ,max(substr(replace(descrip,chr(10),' '),1,40)) descrip , round(avg(pr_precio),2) med_precio , sum(c_uni1) unid , NVL(round(sum(i_netoemp),0),0) importe , count(1) lineas ,NVL(sum( case when sysdate - f_Albaran <= 30 then c_uni1 else 0 end ),0) c_30_d ,NVL(sum( case when sysdate - f_Albaran <= 30 then i_netoemp else 0 end ),0) i_30_d ,NVL(sum( case when sysdate - f_Albaran > 30 and sysdate - f_Albaran <= 180 then c_uni1 else 0 end ),0) c_180_d ,NVL(sum( case when sysdate - f_Albaran > 30 and sysdate - f_Albaran <= 180 then i_netoemp else 0 end ),0) i_180_d ,NVL(sum( case when sysdate - f_Albaran > 180 then c_uni1 else 0 end ),0) c_mas_d ,NVL(sum( case when sysdate - f_Albaran > 180 then i_netoemp else 0 end ),0) i_mas_d from ggalblinv where ggclipr_cod = '10' group by gaart_cod order by 5 desc; ) e: SQLSTATE[HY000]: General error: 911 OCIStmtExecute: ORA-00911: carácter no válido (ext\pdo_oci\oci_statement.c:148) args: Array ( ) en historicoarticuloscliente() (línea 1317 de C:\wamp\www\titania\sites\all\modules\titania\titania.module).
| Comment | File | Size | Author |
|---|
Comments
Comment #1
bohartD7 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!