Hi,
I am creating a rowset in an sql database function.
I then need to adjust each rows content and possible add extra columns
before passing back to callable statement in my javabean.
Can any one tell me what the sytax is to loop through my rowset and
manipulate the rowset fields?
Example funtion:
************
Function list_transactions (
p_cust_id IN customers.cust_id%TYPE,
p_inst_id IN customers.inst_id%TYPE,
p_supply_type IN customers.supply_type%TYPE
) return mytransactions AS
rc mytransactions;
BEGIN
open rc for SELECT tran_date, tran_amnt
FROM TRANSACTIONS
WHERE cust_id = p_cust_id
***********************************************
*** Now I need to alter the contents of each record
*** of rc before returning it.
***********************************************
return rc;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END list_transactions;
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
