Home » SQL & PL/SQL » SQL & PL/SQL » oracle stored procedures and JDBC result sets
oracle stored procedures and JDBC result sets [message #37191] Wed, 23 January 2002 13:07 Go to next message
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.
Re: oracle stored procedures and JDBC result sets [message #37193 is a reply to message #37191] Wed, 23 January 2002 13:44 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://osi.oracle.com/~tkyte/ResultSets/index.html
Previous Topic: comparing two tables data
Next Topic: Can't drop storeprocedure.
Goto Forum:
  


Current Time: Mon Aug 02 10:50:46 CDT 2021