Skip to Content
0
Former Member
Feb 26, 2009 at 04:19 PM

File to JDBC Scenario using stored procedure Question

21 Views

Does anyone have an aswer (or have you seen a Blog that covers it) to the problem of having to do a table refresh before doing inserts in a file 2 jdbc scenario?

Essentially the details are as follows:

I have an input file that has all the data for a table (it's a complete table dump) of lets say userdata (username, name, hiredate).

I need to pass that to an oracle database via stored procedure(s). But before I start issuing my insert (via insert stored procedure) I have to somehow issue a delete statement to delete all the contents of the table I'm about to update. I'm on XI 3.0 and aren't sure what the best solution to this may be.

Again if there is a blog that covers this then if you could point me in that direction it would be great. Otherwise if anyone has any good ideas it would be appreciated.