ETL and Data Integration tools - Modern ETL software for everyone

Hi
I am scheduling the following script but its failing every day but its running from sql without any issue.
The following scripts giving errorr ORA-00900: invalid SQL statement from the db soft library but working fine from any other sql tools.

rgds
jelson


insert into GBTB_FNS_TXNS_DEL
select * from gbtb_fns_txns
where j_no in(select ref_no from FLX_FNS_REC)
and load_type is null

delete from gbtb_glfcc_txns a
where exists
(select b.trn_dt
from FLX_FNS_REC b
where a.TRN_DT = b.TRN_DT
and a.AC_BRANCH = b.AC_BRANCH
and a.ADDL_TEXT = b.ADDL_TEXT
and (a.LCY_AMOUNT = b.LCY_AMOUNT or a.FCY_AMOUNT = b.FCY_AMOUNT))

You need to specify the delimiter

/ is a delimiter


insert into GBTB_FNS_TXNS_DEL
select * from gbtb_fns_txns
where j_no in(select ref_no from FLX_FNS_REC)
and load_type is null
/
delete from gbtb_glfcc_txns a
where exists
(select b.trn_dt
from FLX_FNS_REC b
where a.TRN_DT = b.TRN_DT
and a.AC_BRANCH = b.AC_BRANCH
and a.ADDL_TEXT = b.ADDL_TEXT
and (a.LCY_AMOUNT = b.LCY_AMOUNT or a.FCY_AMOUNT = b.FCY_AMOUNT))

/

Still no luck

J

So have specified delimiter or not? as on picture below?

If you did and it does not work email us screen shot so we can see what is happenings

Mike