One Star

tOracleBulkExec

Hello,
I want to know why this error occured?
Please help me.
=========================================================================
connecting to socket on port 3541
connected
Exception in component tOracleBulkExec_2
java.io.IOException: Cannot run program "sqlldr": CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessBuilder.start(ProcessBuilder.java:460)
at java.lang.Runtime.exec(Runtime.java:593)
at java.lang.Runtime.exec(Runtime.java:431)
at java.lang.Runtime.exec(Runtime.java:369)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.tOracleBulkExec_2Process(TBMD_SPOT_ORD_TMP1.java:492)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.runJobInTOS(TBMD_SPOT_ORD_TMP1.java:858)
at tbmd_spot_ord.tbmd_spot_ord_tmp1_0_1.TBMD_SPOT_ORD_TMP1.main(TBMD_SPOT_ORD_TMP1.java:717)
Caused by: java.io.IOException: CreateProcess error=2, ??d?? Æ???; ?; ¼? ¾ø
at java.lang.ProcessImpl.create(Native Method)
at java.lang.ProcessImpl.<init>(ProcessImpl.java:81)
at java.lang.ProcessImpl.start(ProcessImpl.java:30)
at java.lang.ProcessBuilder.start(ProcessBuilder.java:453)
... 6 more
disconnected
=============================================================
5 REPLIES
One Star

Re: tOracleBulkExec

Hi
The tOracleBulkExec component uses sqlldr program to load a flat file for better performance.
You need to make sure two things.
No.1: Check whether there is Oracle or sqlldr installed in your local machine.
No.2: Check whether you have set Oracle environment variables for sqlldr correctly.
Regards,
Pedro
One Star

Re: tOracleBulkExec

Thanks pedro.
How can I do setting sqlldr in tOracleBulkExec component?
And how can I do mapping from input data to output table?
tOracleInput ---------------- tFileOutputDelimited (input data)
|
|
|
tOracleBulkExec (output table)
One Star

Re: tOracleBulkExec

Hi
The setting of sqlldr, in fact, is an issue about Oracle. So do you install Oracle in your local machine?
For sqlldr environment variable, you might find info from google.
Besides, I think you'd better use tOracleOutputBulk instead of tFileOutputDelimited.
Regards,
Pedro
One Star

Re: tOracleBulkExec

Oracle 10g setting
NLS_LANG : AMERICAN_AMERICA.KO16MSWIN949

How do I set up in tOraclebulkExec??
Is it right?
One Star

Re: tOracleBulkExec

Hi
In fact, this is not an issue about how to configure tOraclebulkExec.
It's an issue about SQLLDR environment variables.
Type 'SQLLDR' in cmd. If this command is recognized and you can see parameters info about 'SQLLDR', tOracleBulkExec will work fine.
If not, you need to configure SQLLDR environment variables.
Here is the URL about SQLLDR.
http://www.ordba.net/Tutorials/OracleUtilities~SQLLoader.htm
In short, make sure 'sqlldr' can run in commandline.
Regards,
Pedro