Consulta erronea query
Publicado por Hector (1 intervención) el 04/09/2021 19:57:08
Buenas tardes.
Quisiera de su sabiduría para saber que es lo incorrecto en este query
este es el error que aparece
Error que empieza en la línea: 16 del comando -
UPDATE TEC_comms_HISTORY_202108 SET CO_DATA='&{"subject":"Facturación Telcel","attachments":[],"documents":[{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'XML'","password":null,"file-type":"pretty-page","file-name":"XML_011148740_19082021.xml","view":null,"document-name":"CFDI1"},{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'PDF'","password":"TGC1","file-type":"pdf","file-name":"FACT_011148740_19082021.pdf","view":null,"document-name":"FACT1"}],"package-attachments":{"generate":true,"password":"TGC1"},"embedded-images":true,"track":true,"actions":[]}&''WHERE CO_BATCH='5340530' AND CO_CLIENT_KEY='01-011148740' AND CO_DATA LIKE '%PWD_ZIP%';
Error en la línea de comandos : 16 Columna : 282
Informe de error -
Error SQL: ORA-00933: comando SQL no terminado correctamente
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
Quisiera de su sabiduría para saber que es lo incorrecto en este query
1
2
UPDATE TEC_comms_HISTORY_202108 SET CO_DATA='&{"subject":"Facturación Telcel","attachments":[],"documents":[{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'XML'","password":null,"file-type":"pretty-page","file-name":"XML_011148740_19082021.xml","view":null,"document-name":"CFDI1"},{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'PDF'","password":"TGC1","file-type":"pdf","file-name":"FACT_011148740_19082021.pdf","view":null,"document-name":"FACT1"}],"package-attachments":{"generate":true,"password":"TGC1"},"embedded-images":true,"track":true,"actions":[]}&''WHERE CO_BATCH='5340530' AND CO_CLIENT_KEY='01-011148740' AND CO_DATA LIKE '%PWD_ZIP%';
este es el error que aparece
Error que empieza en la línea: 16 del comando -
UPDATE TEC_comms_HISTORY_202108 SET CO_DATA='&{"subject":"Facturación Telcel","attachments":[],"documents":[{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'XML'","password":null,"file-type":"pretty-page","file-name":"XML_011148740_19082021.xml","view":null,"document-name":"CFDI1"},{"type":"cvcfdi","library":"MOBILE","task":"CICLOS","report":"MOBPRD1.R01","issue-title":"MOBPRD1.R01.MI20.CFDPDOCO.2210819.bin","issue-date":"20-08-2021","query":"UIDLIKE '55CE11BF-CFF9-4037-8C72-DFB4413AC52E' AND DOCTYPE LIKE 'PDF'","password":"TGC1","file-type":"pdf","file-name":"FACT_011148740_19082021.pdf","view":null,"document-name":"FACT1"}],"package-attachments":{"generate":true,"password":"TGC1"},"embedded-images":true,"track":true,"actions":[]}&''WHERE CO_BATCH='5340530' AND CO_CLIENT_KEY='01-011148740' AND CO_DATA LIKE '%PWD_ZIP%';
Error en la línea de comandos : 16 Columna : 282
Informe de error -
Error SQL: ORA-00933: comando SQL no terminado correctamente
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
Valora esta pregunta


0