Bulk Insert in D2K forms PLL [message #380071] |
Fri, 09 January 2009 00:48 |
bimal_kaur
Messages: 4 Registered: March 2007 Location: delhi
|
Junior Member |
|
|
Hi,
Can anyone suggest how can I insert bulk data into a table through a PLL?
I am collecting data from a form and the row to be inserted in the table has 4 values.
These 4 values are fetched from the form depending upon loggin information of the user.
So, there are 19 different insert statements inserting in the same table and it takes a lot of time as there are 19 insertions seperately taking place.
I thought of inserting using a temporary table and then using FORALL to bulk insert, but unlike PL\SQL, D2K form doesnot recognize FORALL keyword.
Please suggest some good solutions.
thanks
|
|
|