| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Passing Multiple Records
Listers,
We recently started converting a client's mainframe system to a web-based system using JSP (Java Server Pages) technology. We use JDBC drivers to connect to an Oracle8i database. The developers want to use stored procedures to handle inserts/updates.
My exposure to the java environment is practically
nil. I'm thinking of creating stored procedures which
would use static SQL statements to perform the DML
operations. While this would handle single record
screens I'm stumped on how to handle multi-record
screens as we want to pass these records one screenful
(between 10 and 15 records) at a time for
manipulation.
I'm open to any suggestions.
Also, is it practical to have these DML statements as stored procedures or would it be better to have the developers code them directly in the pages.
Your thoughts are comments are welcomed.
 |
 |