error -06575
Publicado por Evelyn (1 intervención) el 25/08/2023 00:01:24
SELECT GRUPO, CODGES, COUNT(DISTINCT AFIL_NRUT) AFILIADOS, SUM(FN_CARGAS(F.AFIL_NRUT,F.ISAP_CEMPRESA, 202208)) CARGAS
FROM GESTION.FINIQ F
WHERE
GRUPO IN (534,535, 3534, 3535)
GROUP BY GRUPO, CODGES
ORDER BY GRUPO,CODGES
Error
ORA-06575: La función o el paquete FN_CARGAS tienen en un estado no válido
06575. 00000 - "Package or function %s is in an invalid state"
*Cause: A SQL statement references a PL/SQL function that is in an
invalid state. Oracle attempted to compile the function, but
detected errors.
*Action: Check the SQL statement and the PL/SQL function for syntax
errors or incorrectly assigned, or missing, privileges for a
referenced object.
Error en la línea: 1, columna: 64
FROM GESTION.FINIQ F
WHERE
GRUPO IN (534,535, 3534, 3535)
GROUP BY GRUPO, CODGES
ORDER BY GRUPO,CODGES
Error
ORA-06575: La función o el paquete FN_CARGAS tienen en un estado no válido
06575. 00000 - "Package or function %s is in an invalid state"
*Cause: A SQL statement references a PL/SQL function that is in an
invalid state. Oracle attempted to compile the function, but
detected errors.
*Action: Check the SQL statement and the PL/SQL function for syntax
errors or incorrectly assigned, or missing, privileges for a
referenced object.
Error en la línea: 1, columna: 64
Valora esta pregunta
0
