db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: unable to execute procedure
Date Wed, 05 Apr 2006 00:46:38 GMT
Anil Samuel wrote:

> Thanks all for the pros/cons of PreparedStatement; That code snippet was
> only *meant* to depict the problem I had with the procedure call and no way
> a coding practise !!
> 
> Ok. I tried this and still no different; below is the result
> ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath','
> dtp.LeaveApp_jar');
> 0 rows inserted/updated/deleted
> ij> CALL dtp.TOTAL_LEAVE_FOR_TYPE('TOM',3);
> ERROR 42Y03: 'DTP.TOTAL_LEAVE_FOR_TYPE' is not recognized as a function or
> procedure.

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.



Mime
View raw message