To mimic a foreign function prototype with PL/SQL:
Here is an example of mimicking a foreign function definition:
PACKAGE calc IS
FUNCTION ADD(X IN BINARY_INTEGER, Y IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
END;
PACKAGE BODY calc IS
/*
Given the foreign function prototype, int ADD(int X, int y),
and the associated PL/SQL subprogram,
FUNCTION ff_ADD(ff_handle,X,Y),
this example shows how to mimic the foreign function
definition in PL/SQL.
*/
FUNCTION ADD(X IN BINARY_INTEGER, Y IN BINARY_INTEGER)
RETURN BINARY_INTEGER IS
BEGIN
RETURN(ff_ADD(ff_ADD_HANDLE,X,Y));
END;
BEGIN
...
END;