Hi
When I execute select sentence to a oracle external database I obtain ORA-00909, when I see the log I see one change at select sentence from GGCLICLASI_GGCLASIF field to GGCLICLASI_GGCLAScase .
Any idea?
Mensaje PDOException: SELECT * FROM ( SELECT A.COD ,A.RSOCIAL_COD ,A.NOMBRE NOMBRE_CLI ,ALBVAL_SN ALBVAL_CLI , F_ULT_OPE ,NVL(GGCLICLASI_GGCLASIF(A.EMPGRUPO_COD,A.TIP_VC,A.COD,'RESTOS'),'S') RESTOS_CLI ,NVL(GGCLICLASI_GGCLASIF(A.EMPGRUPO_COD,A.TIP_VC,A.COD,'CAJAS'),'N') CAJAS_CLI ,NVL(GGCLICLASI_GGCLASIF(A.EMPGRUPO_COD,A.TIP_VC,A.COD,'ENVIA_DOC'),'S') ENVIA_CLI ,(SELECT DESCRIP FROM GGESTADO WHERE TIP_VCAP = A.TIP_VC AND COD = A.GGESTADO_COD) ESTADO ,DECODE(SUBSTR(A.COD,1,1),'1','VG01','3','SG03','5','SG05',A.EMP_MASTER) EMPRESA ,(SELECT POBLAC_NOM FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) LOCALIDAD ,(SELECT REPLACE(TELEFONOS,' ',NULL) FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) TELEFONO ,(SELECT E_MAIL FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) MAIL FROM GGCLIPR A, GVCLIAGE B WHERE A.EMPGRUPO_COD = B.EMPGRUPO_COD AND A.TIP_VC = B.TIP_VC AND a.cod='10' AND A.COD = B.COD AND A.F_BAJA IS NULL AND B.GVAGENTE_COD = '10') order by nombre_cli (prepared: SELECT * FROM ( SELECT A.COD ,A.RSOCIAL_COD ,A.NOMBRE NOMBRE_CLI ,ALBVAL_SN ALBVAL_CLI , F_ULT_OPE ,NVL(GGCLICLASI_GGCLAScase when A.EMPGRUPO_COD then A.TIP_VC else A.COD,'RESTOS' end,'S') RESTOS_CLI ,NVL(GGCLICLASI_GGCLAScase when A.EMPGRUPO_COD then A.TIP_VC else A.COD,'CAJAS' end,'N') CAJAS_CLI ,NVL(GGCLICLASI_GGCLAScase when A.EMPGRUPO_COD then A.TIP_VC else A.COD,'ENVIA_DOC' end,'S') ENVIA_CLI ,(SELECT DESCRIP FROM GGESTADO WHERE TIP_VCAP = A.TIP_VC AND COD = A.GGESTADO_COD) ESTADO ,DECODE(SUBSTR(A.COD,1,1),'1','VG01','3','SG03','5','SG05',A.EMP_MASTER) EMPRESA ,(SELECT POBLAC_NOM FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) LOCALIDAD ,(SELECT REPLACE(TELEFONOS,' ',NULL) FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) TELEFONO ,(SELECT E_MAIL FROM RSOCDIR WHERE RSOCIAL_COD = A.RSOCIAL_COD AND COD = A.RSOCDIR_ENV) MAIL FROM GGCLIPR A, GVCLIAGE B WHERE A.EMPGRUPO_COD = B.EMPGRUPO_COD AND A.TIP_VC = B.TIP_VC AND a.cod='10' AND A.COD = B.COD AND A.F_BAJA IS NULL AND B.GVAGENTE_COD = '10') order by nombre_cli ) e: SQLSTATE[HY000]: General error: 909 OCIStmtExecute: ORA-00909: número de argumentos no válido (ext\pdo_oci\oci_statement.c:148) args: Array ( ) en _bd_obtenerCliente() (línea 3720 de C:\wamp\www\titania\sites\all\modules\titania\titania.module).
Comments
Comment #1
Anonymous (not verified) commentedHere the same issue