Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle insert multiple rows in a stored procedure

Re: Oracle insert multiple rows in a stored procedure

From: Johannes Gajdosik <johannes.gajdosik_at_siemens.at>
Date: Tue, 24 Aug 1999 17:41:29 +0200
Message-ID: <37C2BD29.A946F6EA@siemens.at>


Eamonn Keating wrote:

> Is it possible to write a stored procedure in Oracle to Insert multiple
> rows into a table. If so, what kind of data type would you pass it from
> visual basic

Try the FORALL statement of Oracle 8i.
Anyone who knows more about bulk inserts in PL/SQL please answer. Johannes Received on Tue Aug 24 1999 - 10:41:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US