Home » Applications » Oracle Fusion Apps & E-Business Suite » Bulk Insert in D2K forms PLL (Forms, D2K)
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

Previous Topic: AP PERIOD CANNOT BE CLOSED
Next Topic: Mass Addition
Goto Forum:
  


Current Time: Sat Dec 10 09:01:40 CST 2016

Total time taken to generate the page: 0.09434 seconds