db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anil Samuel" <anil.sam...@gmail.com>
Subject Re: unable to execute procedure
Date Wed, 05 Apr 2006 00:56:05 GMT
>
>
> 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

Mime
View raw message