Well a little more explaination might help. But are you talking about a Java Stored Procedure returning an int, or a PL/SQL procedure returning an int? PL/SQL can return a Number, and you can have a Java Stored Procedure return an int but then Oracle will convert it to a number. Is this what you are asking? Mark