Since I have never tried this myself, I did a little research on Google Groups using the search term "JDBC drivers sql stored procedures" and came up with some articles that might help you. It does look like it is possible, although a pain in the rear. You might have to code a cursor because it looks like a PL/SQL procedue can only handle one row at a time. But again, I have not ever tried this before, so your best bet is to check out Google Groups. Hope this helps a little.
~Firegirl~
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.
Firegirl posted this at 16:30 — 1st August 2006.
She has: 54 posts
Joined: Jun 2006
Since I have never tried this myself, I did a little research on Google Groups using the search term "JDBC drivers sql stored procedures" and came up with some articles that might help you. It does look like it is possible, although a pain in the rear. You might have to code a cursor because it looks like a PL/SQL procedue can only handle one row at a time. But again, I have not ever tried this before, so your best bet is to check out Google Groups. Hope this helps a little.
~Firegirl~
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.