OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Bulk Insert in D2K forms PLL (Forms, D2K)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 00:15:23 CDT 2024