Home » Developer & Programmer » Forms » compiling error when using bulk collect in oracle form 10g (form 10g.window7)
compiling error when using bulk collect in oracle form 10g [message #447537] Mon, 15 March 2010 22:34 Go to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi all,

i am getting compilling error when using bulk collect in oracle

form 10g

Quote:
this feture is not supported on client-side programs


best Regards
jitender sadh
=============
Re: compiling error when using bulk collect in oracle form 10g [message #447576 is a reply to message #447537] Tue, 16 March 2010 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that Forms' PL/SQL engine doesn't support bulk collect.

What you might try to do is to create a stored procedure which will do that job, and call the procedure from your form.
Re: compiling error when using bulk collect in oracle form 10g [message #478340 is a reply to message #447576] Fri, 08 October 2010 01:20 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

But if we write BULK COLLECT Statement in procedure body in form 10g..its not work...
that means ...we can use this statement only at backend...
Re: compiling error when using bulk collect in oracle form 10g [message #478355 is a reply to message #478340] Fri, 08 October 2010 03:13 Go to previous message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
swapnil_naik wrote on Fri, 08 October 2010 08:20
we can use this statement only at backend...


That would be a "stored procedure".
Previous Topic: Disable Menu Item
Next Topic: Display Item Is Not showing Result
Goto Forum:
  


Current Time: Wed Sep 28 04:02:38 CDT 2016

Total time taken to generate the page: 0.25956 seconds