| RefCursor inside Forms Procedure [message #163500] |
Thu, 16 March 2006 23:42  |
nirmalnarayan
Messages: 261
Registered: April 2005
Location: India
|
Senior Member |
|
|
Fetch Dtl_Cur Bulk Collect into Dtl_Rec;
The Above statement is giving compilation error that 'This feature is not supported in client-side programs'
I have declared this REF CURSOR inside a procedure in a package in the Forms.
Does it mean that REF CURSOR is not allowed in FORMS
Nirmal
[Updated on: Thu, 16 March 2006 23:51] Report message to a moderator |
|
|
|
| Re: RefCursor inside Forms Procedure [message #163736 is a reply to message #163500] |
Sun, 19 March 2006 02:36  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Bulk operations are a server side PL/SQL feature, that's what Forms is complaining about. The Forms PL/SQL engine doesn't know how to handle this. If you really have a lot of records to handle and a bulk operation would significantly speed up the process, you shouldn't do it in Forms anyway.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
