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
