[resolved] Execute Script sql to Oracle from file

[catusse]

Hi,
I Have done a file sql (with a tMap componant) and I want to load it into Oracle.
Which component should I use?
I 've got 200 request like this:
update OG.COORDONNEES
set OG.COORDONNEES.MEL_PRO1='mail1',
OG.COORDONNEES.NUM_TELPRO1='00000',
OG.COORDONNEES.NUM_POSTPRO1='0000'
WHERE OG.COORDONNEES.COORD_ID in (
select OG.COORDONNEES.COORD_ID
from OG.COORDONNEES, rh.agtnat , OG.IDENT
where rh.agtnat.idf_agent=XXX
AND RH.AGTNAT.IDENT_ID=OG.IDENT.IDENT_ID AND
OG.IDENT.COORD_ID=OG.COORDONNEES.COORD_ID
AND RH.AGTNAT.COD_COLL ='ZZZZ'
)
Is there another way to do this without using an sql script?
Tank's for your help.

[Anonymous]

For this purpose I have created a parser which can separate statements and run them separately.
You find this component tSQLScriptParser in Talend Exchange.

[Anonymous]

shong,
i have the similar problem your screenshots are missing to define te tjavaflex can ou please guide me i have a huge sql to execute and then union the result set with normal result inthe job.can you please guide me?

[Anonymous]

Hi sanjana
I did't upload screenshots to this topic before, please refer to the component manual and learn the basic usage of tJavaFlex.
Best regards
Shong