| oracle stored procedures and JDBC result sets [message #37191] |
Wed, 23 January 2002 13:07  |
elenor skific
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
Hi,
I need your help urgently.
I need to write an oracle stored procedure that returns
a readable JDBC result using oracle 7.
It is not just a straight-forward select and display.
I need to select data from a "rate table", then
perform calculations and return 1-many "charge name"
and "amount" rows in a JDBC result set format for
each matching row found in the "rate table".
Neither chg name nor amt are fields in the "rate table". I must determine these based on "charge code"
and "rate" in the "rate_table"
I have written a procedure using multiple cursors
(c1, c2, etc) using FOR calc_rate1 in c1 LOOP ...
using 'DMBS_OUTPUT.PUT_LINE' for testing purposes
and the procedure compiles and displays correct
results using SQLPLUS, but our in-house web
developer can't execute my procedure because
no result set is produced.
I have some examples of REF CURSOR constructs
using functions but cannot see how to apply
this to what I need to do.
Please help me. Thank you.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
