Get SQL Return Value

I'm trying to figure out the syntax (java) for retrieving the return value from a SQL statement... so in java I'm calling some sql stored procedure that does:

SELECT * FROM Something

Return 1

How do I get the return value from the SQL Stored Procedure?

Thanks in advance for any help!

[317 byte] By [crimminsda] at [2007-11-27 8:18:48]