thaks for the update !!! ________________________________
From: A mailing list about Java Server Pages specification and reference on behalf of Emmanuel Eze Sent: Wed 6/28/2006 4:18 PM To: JSP-INTEREST@JAVA.SUN.COM Subject: Re: Sending an Array to a stored procedure:pls help Check out http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3696816290928 Good luck, Emmanuel Eze http://emma.ukrosoft.com [Kiran Kumar Vedula] wrote: >hi > I need help on how to send a Array as an input to a stored >procedure.Please let me know..... > >I am stuck with that for last one day... > >sample stored procedure is here: >create or replace package test_long_bulk_in_pack_bo as > TYPE tab_type_items IS TABLE OF TEST_LOG_BULK_INSERT%ROWTYPE; > -- t_tab_items tab_type_items := tab_type_items(); > procedure testt(t_tab tab_type_items); > end; > > >create or replace package body test_long_bulk_in_pack_bo > as > PROCEDURE testt(t_tab tab_type_items) > IS > > BEGIN > FOR J IN t_tab.first .. t_tab.last LOOP > insert into TEST_LOG_BULK_INSERT values(1,'DDDD'); > END LOOP; > END; > end; > > > >If possible , pls send me any code for the above stored proc.. > >kiran > >=========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > >Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > > > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
