Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

load data from a file to oracle table using bulk exec

hi talend pro
i have a problem i use tfileinputdelimited --> toracleoutputbulkexec
but it does'nt work
because this error : java.io.FileNotFoundException: C:\out.csv (Access is denied)
i need help please can you show me how i do the bulk load from a file to a oracle table
and thanks for your great help
0683p000009MEVe.jpg 0683p000009MEWw.jpg
Labels (3)
5 Replies
Anonymous
Not applicable
Author

hi,
as message tell you : you don't have permission to write in C:/ .
choose another location.
regards
laurent
Anonymous
Not applicable
Author

Whether the metadata is created for input file?
Error says that the file is not generated based on input file.. Whether the file exists in the c:\?
vaibhav
Anonymous
Not applicable
Author

Thanks laurent for your reply
but what's the problem with the c:/ i don't think so
Thanks vaibhav for your reply , can you explain to me how can i do this becaue there is a file which his path in the file name generated by the same data of my tfileinputdelimited ? and what should i do
thanks for your help
Anonymous
Not applicable
Author

could you try to bulk your data with OracleBulk + OracleExec (do the same think that OutputBulkExec but using 2 components)
Also try to write a simple flat file in c:\ (just a test 0683p000009MACn.png
regards
Anonymous
Not applicable
Author

Thanks kzone for your help
i try of course with toracleoutputbulk and toraclebulkexec
then if i met in the file name of the component toracleoutputbulk the path of my tfileinputdelimited
this componenent writes data in the same data
and if i met a new path i have this error :Exception in component tOracleOutputBulk_1
java.io.FileNotFoundException: C:\out.csv (Access is denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(Unknown Source)
at java.io.FileOutputStream.<init>(Unknown Source)
can you show me by example how i do this and thanks