tOracleOutputBulk and tOracleBulkExec components

One Star

tOracleOutputBulk and tOracleBulkExec components

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)

Thanks,
Pankaj
Moderator

Re: tOracleOutputBulk and tOracleBulkExec components

Hi Pankaj,
Did your DB oracle support for "bulk"? Have you tried to use tOracleOutputBulkExec to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tOracleOutputBulk and tOracleBulkExec components

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.


M I missing something???