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).

CommentFileSizeAuthor
Captura de pantalla 2012-03-27 a la(s) 21.35.12.png72.26 KBAnonymous (not verified)

Comments

bohart’s picture

Version: 7.x-1.12 » 7.x-1.x-dev
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.