So you can't use CALL for a function. I sent the examples of a function
use earlier, using the VALUES or SELECT statements.

Dan.

I created a PROCEDURE using
CREATE PROCEDURE dtp.TOTAL_LEAVE_FOR_TYPE (
  EMPLOYEE CHAR(80),
  LEAVE_TYPE_ID INT,
  OUT TOTAL_LEAVE INT)
        LANGUAGE JAVA
        EXTERNAL NAME ' oracle.dtp.derby.sample.LeaveHelper.TotalLeaveForType '
        PARAMETER STYLE JAVA;

not a FUNCTION.



--
Anil Samuel <anil.samuel@oracle.com>
Senior Technical Member
Product Development
Oracle Corporation