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???

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now