 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | Sending an Array to a stored procedure:pls help | Sending an Array to a stored procedure:pls help 2006-06-28 - By [Kiran Kumar Vedula]
Back
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@(protected)
Subject: Re: Sending an Array to a stored procedure:pls help
Check out
http://asktom.oracle.com/pls/ask/f?pI50: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 listserv@(protected) with body: "signoff JSP-INTEREST".
>For digest: mailto listserv@(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 listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(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 listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(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
|
|
|
