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!

CALL A FUNCTION INSIDE THE LOOP

781692Oct 3 2010 — edited Oct 5 2010
hi all,
i have a function get_conversion()
four in parameter and one out parameter. hwo to call that function inside the loop;
i called like
select get_conversion(company,from_uom,to_uom,value,err_msg) into variable1 from dual;
and writing the variable1 into the output file.
except 'err_msg' other parameters are in parameters.
but i am getting the ora-06572(i have written the code in the when-button-pressed trigger).
Please help me how to call a procedure.

Thanks..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2010
Added on Oct 3 2010
11 comments
2,725 views