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.
