A script-enabled browser is required for this page to function properly.

Returning Values from a Foreign Function Using PL/SQL

Returning a value from a foreign function to a Oracle Forms variable or item is similar to returning a value from any PL/SQL function. Be sure to register the return value when you create the PL/SQL interface.

You obtain a return value from a foreign function by assigning the return value to a 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.

Returning a value from a foreign function using PL/SQL: Example

/*
 The BINARY_INTEGER that the ADD foreign function returns is
 assigned to the item sum_itm of the block addblk.
*/
BEGIN
 addblk.sum_itm:= ADD(X_Val, Y_Val);
END;


Passing parameter values to a foreign function using PL/SQL

Simplifying complex parameter data types