Hi, I created a DB connection (oracle11g) and created a job using toraceloutput componet and it works fine. Now I used same connection but with tOracleOutputBulk and tOracleBulkExec components and suddenly it giving me error .
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach ORA-12545: Connect failed because target host or object does not exist Exception in component tOracleOutputBulkExec_1_tOBE java.lang.Exception at testparallelprocessing.testpapo_0_1.TestPaPo.tFileInputDelimited_1Process(TestPaPo.java:5308) at testparallelprocessing.testpapo_0_1.TestPaPo$6.run(TestPaPo.java:6843)
Hi Sabarina,
I was trying out
tOracleOutputBulkExec component and it gave me above error.
Did your DB oracle support for "bulk"? Have you tried to use tOracleOutputBulkExec to see if it works?
How to check if my DB supports "Bulk" . If you talking about bulk collect then oracle supports it.
---------------
After this I defined connection using option "Oracle SID" .
Now it doest give me any error but doesn't commit also .
and console output :
Starting job TestPaPo at 16:34 27/07/2015. connecting to socket on port 3871 connected SQL*Loader: Release 11.XX.XXXX - Production on Mon Jul 27 16:34:59 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. disconnected Job TestPaPo ended at 16:35 27/07/2015.
