DEVFYI - Developer Resource - FYI

Can you pass values to-and-fro from foreign function ? how ?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

655. Can you pass values to-and-fro from foreign function ? how ?

Yes . You obtain a return value from a foreign function by assigning the return value to an Oracle Forms variable or item. Make sure that the Oracle Forms variable or item is the same data type as the return value from the foreign function.
After assigning an Oracle Forms variable or item value to a PL/SQL variable, pass the PL/SQL variable as a parameter value in the PL/SQL interface of the foreign function. The PL/SQL variable that is passed as a parameter must be a valid PL/SQL data type; it must also be the appropriate parameter type as defined in the PL/SQL interface.

(Continued on next question...)

Other Interview Questions