[resolved] Problem with using existing connection (oracle)

[Anonymous]

Hi,
I have a similar issue as posted by Jijli early today.  Table truncated but no data inserted.  I have a simple job:

tOracleconnection_1 -  property type, repository.  Use or register a shared DB connection box check, and shared name entered.
tFileInputPositional_1 -  pick up a fixed width text file with repository schema applied. limited 50 rows
tOracleOutput_1 -  used an existing connection box checked.  component list "tOracleconnection_1" in yellow color.  Action on table - truncate, action on data- insert, schema-repository, die on error box checked.  Dynamic setting, component list and tOracleConnection_1.

I ran it with no errors.  I check the oracle table truncated but no data inserted.  It works fine without using an existing connection.



Please help.
Thanks
Andy

[Anonymous]

thanks to put post as resolved

regards