user554531 wrote:I think that Billy Verreynne has already given you the best suggestion regarding your code:
I have posted both code and data format if you see the first 2 posts of this thread
I would not add code to this procedure. I would trash it. And then go back to the drawing board with the question - what are the requirements?Regards.
user554531 wrote:What about describing requirements? Please describe what you want to do with this procedure.
Any advise how to rewrite the code will be greatly appreciated.
user554531 wrote:Why use Java to process the file? Oracle has SQL*Loader and supports files as external tables. Keep in mind the distance file data needs to travel in your approach. All the way from disk into Java across JDBC into PL/SQL and then to SQL and then finally to disk again.
Below are the requirements:
A file will be uploaded from front end .
Data from the file will be sent as arraya from java code:
Two types of data
1. values from file
2. array of string values
I have to run the select query based on each value .So if there are a million lines to process in the file, you need to execute a million SQLs. Bad idea.