Hi, all.
I have the following Oracle SQL:
SELECT C1.LGNUM C_DEP,
TRUNC(C1.IVNUM) N_DOC,
C1.IVPOS POS_DOC,
DECODE (LINK1.NVERS,'00','1','01','2','02','3','03','4','04','5','N') ULT_CONTAGEM,
DECODE (LINK1.ISTAT,'A','CONTAGEMPARCIAL','L','RETIFICADO','N','NAO CONTADO','Z','CONTADO','S','ESTORNADO','D','INV.ROTATIVO') STATUS_ULT_CONT,
C1.LQNUM QTO,
C1.LGORT DEP,
C1.LGTYP TIPO_DEP,
C1.LGPLA POS_DEP,
MARCABC.MAABC ABC,
DECODE(MARCABC.MAABC,'A','0','B','0,02','0,04') TOLERANCIA,
C1.MATNR MATERIAL,
C1.WERKS CENTRO,
LINK1.PDATU DATA_INI,
C1.MEINS UMB,
C1.CHARG LOTE,
SUBSTR(C1.LENUM,11,15) UD,
QTO.GESME QTDE_SISTEMA,
C1.MENGE QTDE_CONTADA_1,
C2.MENGE QTDE_CONTADA_2,
(C2.MENGE-C1.MENGE) VAR_CONT2_MENOS_CONT1,
C3.MENGE QTDE_CONTADA_3,
(C3.MENGE/QTO.GESME) VAR_SIST_3,
C1.UNAME CONTADOR_1,
C2.UNAME CONTADOR_2,
C3.UNAME CONTADOR_3,
C4.MENGE C4CONF
FROM (SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LGNUM ||LQNUM CHAVE1, LGNUM||IVNUM||LGTYP CHAVE2, LINV. FROM LINV WHERE NVERS = '00') C1,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '01') C2,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '02') C3,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '03') C4,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '04') C5,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '05') C6,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '06') C7,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '07') C8,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '08') C9,
(SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LINV. FROM LINV WHERE NVERS = '09') C10,
(SELECT LGNUM ||LQNUM CHAVE1, LQUA. FROM LQUA) QTO,
(SELECT MATNR, MAABC FROM MARC WHERE WERKS = '1100') MARCABC,
(SELECT LGNUM||IVNUM||LGTYP CHAVE2, LINK. FROM LINK) LINK1
WHERE C1.CHAVE = C2.CHAVE (+) AND
C1.CHAVE = C3.CHAVE (+)
AND C1.CHAVE = C4.CHAVE (+)
AND C1.CHAVE = C5.CHAVE (+)
AND C1.CHAVE = C6.CHAVE (+)
AND C1.CHAVE = C7.CHAVE (+)
AND C1.CHAVE = C8.CHAVE (+)
AND C1.CHAVE = C9.CHAVE (+)
AND C1.CHAVE = C10.CHAVE (+)
AND C1.CHAVE1 = QTO.CHAVE1 (+)
AND C1.MATNR = MARCABC.MATNR (+)
AND C1.CHAVE2 = LINK1.CHAVE2 (+)
ORDER BY C1.IVNUM, C1.LGNUM, C1.IVPOS
PHPRunner 5.2 (5482) works fine in list / sort / search / filter modes. But, when I try export to any format (Excel, txt, csv) or print the page, the web browser show the following error message:
Informações Técnicas
Tipo de Erro 2
Descrição do Erro ociparse() [function.ociparse]: ORA-01741: identificador de tamanho zero inválido
URL intranet.visum.com.br/Inventario2010PB/output/DD03L_export.php?
Arquivo de Erro C:\Intranet\Apache2.2\htdocs\Inventario2010PB\output\include\dbconnection.php
Linha com Erro 40
Consulta de SQL SELECT "C1"."" as "C_DEP", TRUNC(C1.IVNUM) as "N_DOC", "C1"."" as "POS_DOC", DECODE(LINK1.NVERS, '00', '1', '01', '2', '02', '3', '03', '4', '04', '5', 'N') as "ULT_CONTAGEM", DECODE(LINK1.ISTAT, 'A', 'CONTAGEMPARCIAL', 'L', 'RETIFICADO', 'N', 'NAO CONTADO', 'Z', 'CONTADO', 'S', 'ESTORNADO', 'D', 'INV.ROTATIVO') as "STATUS_ULT_CONT", "C1"."" as "QTO", "C1"."" as "DEP", "C1"."" as "TIPO_DEP", "C1"."" as "POS_DEP", "MARCABC"."" as "ABC", DECODE(MARCABC.MAABC, 'A', '0', 'B', '0,02', '0,04') as "TOLERANCIA", "C1"."" as "MATERIAL", "C1"."" as "CENTRO", "LINK1"."" as "DATA_INI", "C1"."" as "UMB", "C1"."" as "LOTE", SUBSTR(C1.LENUM, 11, 15) as "UD", "QTO"."" as "QTDE_SISTEMA", "C1"."" as "QTDE_CONTADA_1", "C2"."" as "QTDE_CONTADA_2", (C2.MENGE-C1.MENGE) as "VAR_CONT2_MENOS_CONT1", "C3"."" as "QTDE_CONTADA_3", (C3.MENGE/QTO.GESME) as "VAR_SIST_3", "C1"."" as "CONTADOR_1", "C2"."" as "CONTADOR_2", "C3"."" as "CONTADOR_3", "C4"."" as "C4CONF" FROM (SELECT LGNUM||IVNUM||IVPOS||LQNUM CHAVE, LGNUM ||LQNUM CHAVE1, LGNUM...
My database user don't have write rights to create a database view.
Thanks in advance.
