Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass Records in a Block to Procedure with Table Type as parameter

RakinNov 13 2009 — edited Nov 13 2009
Hi,

How can I pass all the records in a Block to PL/SQL procedure with argument as Table Type or Refcursor.

I created one procedure in the backend with one Table Type parameter. From the form, I want to call that procedure with argument as ALL the records in BLOCK.

Is there any simple method for it.


Thanks in advance

Rizly
This post has been answered by CraigB on Nov 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 11 2009
Added on Nov 13 2009
2 comments
992 views