Closed (duplicate)
Project:
Oracle Driver
Version:
7.x-1.9
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Anonymous (not verified)
Created:
12 Jan 2012 at 17:53 UTC
Updated:
24 Jun 2020 at 11:00 UTC
Hi
I have a error when I execute the following sql sentence:
SELECT
(SELECT DESCRIP_ART FROM GACLASIF WHERE COD = X.FAM AND GACLATIP_COD = 'FAM') FAMILIA ,X.I_VENTA_FAC
FROM
( SELECT GAARTCLASI_GACLASIF(A.EMPGRUPO_COD, A.GAART_COD, 'FAM') FAM, NVL(SUM(A.I_NETOEMP),0) AS I_VENTA_FAC FROM GGALBLINV A
WHERE A.GGCLIPR_COD IN (SELECT C.COD FROM GGCLIPR C WHERE C.GVAGENTE_COD = '10' AND C.TIP_VC = 'V')
AND A.TIP_vC = 'V' AND A.N_FACTURA IS NOT NULL AND A.F_ALBARAN BETWEEN SYSDATE-365 AND
SYSDATE AND A.EMPGRUPO_COD = 'DIS' GROUP BY GAARTCLASI_GACLASIF(A.EMPGRUPO_COD, A.GAART_COD, 'FAM')
ORDER BY 2 DESC ) X
WHERE ROWNUM < 10I test that sentence at Oracle SQL Client and it works OK, but when I execute this sentence from drupal I have the following error:
General error: 923 OCIStmtExecute: ORA-00923:
This error is because doesn't find FROM word (ext\pdo_oci\oci_statement.c:148)
I use oracle for a external database. If I execute this sentence using OCI (without PDO) works
Any idea?
Comments
Comment #1
aaaristo commentedthe group by handler... is horrible...
try using $conn->oracleQuery if is a custom module meanwhile..
Comment #2
aaaristo commentedhttp://drupal.org/node/1340368