Re: unable to execute procedure

[Anil Samuel]

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 <[EMAIL PROTECTED]>
Senior Technical Member
Product Development
Oracle Corporation