oracle 00926,ORA-00926: missing VALUES keyword

Dear Bernhard...

I guess you haven't seen this reply from me to all.. Sorry I am new here...

yes its a Oracle schema...

Table looks like that:

BKW_PROCESSDATE 1 Y DATE None 0

BKW_CUTOFFDATE 2 Y DATE None 0

BKW_EXCLBOOK 3 Y VARCHAR2 (2000 Byte) None 0

BKW_EXCLSTATUS 4 Y VARCHAR2 (16 Byte) None 0

BKW_PRODUCT 5 Y VARCHAR2 (16 Byte) None 0

BKW_ALLCOUNTERPARTIES 6 Y NUMBER (1) None 0

BKW_SPECCOUNTERPARTIES 7 Y VARCHAR2 (16 Byte) None 0

BKW_LOADGENERAL 8 Y NUMBER (1) None 0

BKW_LOADTRADE 9 Y NUMBER (1) None 0

BKW_LOADINTERNALTRADE 10 Y NUMBER (1) None 0

BKW_EXLCTRADES 11 Y VARCHAR2 (4000 Byte) None 0

SQL Skripts being tried:

sql( 'EHALLEGRO','insert into EHALLEGRO.ALLEGRO.BKW_MAP_MIG_MIG_VARIABLE (bkw_jobname,bkw_processdate,bkw_cutoffdate,bkw_exclbook,bkw_exclstatus,bkw_product,bkw_allcounterparties,bkw_speccounterparties,bkw_loadgeneral,bkw_loadtrade,bkw_loadinternaltrade,bkw_exlctrades) values ([job_name( )],[sysdate( )],[$GV_CUTOFF_DATE],[$GV_EXCLUDED_BOOKIDS],[$GV_EXCLUDED_CONTRACT_STATUS],[$GV_PRODUCT_LIST],[$GV_INCL_ALL_COUNTERPARTIES],[$GV_INCL_SPEC_COUNTERPARTY],[$GV_LOAD_GENERAL],[$GV_LOAD_TRADE],[$GV_LOAD_INTERNAL_TRADE],[$GV_EXCLUDED_TRADES]))');

sql( 'EHALLEGRO','insert into EHALLEGRO.ALLEGRO.BKW_MAP_MIG_MIG_VARIABLE values ([job_name( )],[sysdate( )],[$GV_CUTOFF_DATE],[$GV_EXCLUDED_BOOKIDS],[$GV_EXCLUDED_CONTRACT_STATUS],[$GV_PRODUCT_LIST],[$GV_INCL_ALL_COUNTERPARTIES],[$GV_INCL_SPEC_COUNTERPARTY],[$GV_LOAD_GENERAL],[$GV_LOAD_TRADE],[$GV_LOAD_INTERNAL_TRADE],[$GV_EXCLUDED_TRADES]))');

If I try it without the datastore.schema.tablename it doesn't find the table..

Thanks for your assistance here.

Cheers

Roland