Hi there,
Got a problem that returns an ora-00900 error code.and i dont see the problem
the query is :
SELECT
aff_type,
aide_aff.fon_refn,
fon_iden,
aide_regl.act_code,
sum( AFF_MNT_FF)
FROM AIDE_AFF, AIDE_REGL, aide_fon
WHERE AIDE_AFF.REGL_NUM = AIDE_REGL.REGL_NUM
and aide_fon.FON_REFN = aide_aff.FON_REFN
and ( to_char(AIDE_REGL.REGL_DATE,'yyyymmdd')
between
to_char(last_day(sysdate-15),'yyyymm') || '01'
and to_char(last_day(sysdate-15),'yyyymmdd'))
and NOT AIDE_REGL.REGL_TYPE_REGL = 'FS'
AND AIDE_AFF.AFF_TYPE = 'MI'
GROUP BY Aide_Aff.Aff_type, aide_aff.fon_refn, fon_iden
and i do get an error on the aide_regl.act_code line with toad
the same without the act_code lines works fine
Act_code is a table from aide_regl (shared with aide_act wich isnt used here, if i declare aide_act, i do get the same errors)
do you see where the error can be ?
thx
Got a problem that returns an ora-00900 error code.and i dont see the problem
the query is :
SELECT
aff_type,
aide_aff.fon_refn,
fon_iden,
aide_regl.act_code,
sum( AFF_MNT_FF)
FROM AIDE_AFF, AIDE_REGL, aide_fon
WHERE AIDE_AFF.REGL_NUM = AIDE_REGL.REGL_NUM
and aide_fon.FON_REFN = aide_aff.FON_REFN
and ( to_char(AIDE_REGL.REGL_DATE,'yyyymmdd')
between
to_char(last_day(sysdate-15),'yyyymm') || '01'
and to_char(last_day(sysdate-15),'yyyymmdd'))
and NOT AIDE_REGL.REGL_TYPE_REGL = 'FS'
AND AIDE_AFF.AFF_TYPE = 'MI'
GROUP BY Aide_Aff.Aff_type, aide_aff.fon_refn, fon_iden
and i do get an error on the aide_regl.act_code line with toad
the same without the act_code lines works fine
Act_code is a table from aide_regl (shared with aide_act wich isnt used here, if i declare aide_act, i do get the same errors)
do you see where the error can be ?
thx