RE: Pass ResultSet / Array of Strings from Java to AS400 StoredProcedure

I'm confused.  Is your AS400 stored procedure in java?  Are you wanting to
call an Oracle stored procedure, have that return a result set and then pass
that result set to the AS400 stored procedure?  Or is the AS400 stored
procedure calling the Oracle stored procedure?

What are the various pieces of your solution, what languages are they
written in, and how to they connect?

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Szabolcs Pall
> Sent: Tuesday, March 22, 2005 10:17 AM
> To: java400-l@xxxxxxxxxxxx
> Subject: Pass ResultSet / Array of Strings from Java to AS400 
> StoredProcedure
> 
> Hi,
> 
> I have some data in Oracle that I retrieve using JDBC, and 
> then want to step through the resultset, updating an AS400 
> Physical File. The resultset has about 10,000 records... so 
> Statement and PreparedStatement are way too slow.
> 
> I want to use CallableStatement but I don't know how to get 
> my resultset to the AS400 stored procedure. Can I pass a Java 
> Resultset to an AS400 Stored Procedure?
> 
> I've thought about dumping the data from Oracle into a 
> data-queue, and then having an RPG program read the data and 
> update the file... are there any other workarounds if I can't 
> pass ResultSets to prepared statements?
> 
> Thanks,
> Szabolcs
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, 
> please take a moment to review the archives at 
> http://archive.midrange.com/java400-l.
>