Hi All

I need to execute oracle stored procedure without out parameter in java and need to take results of that executed procedure in my code. Is it possible to get results without Registering output parameter.If so, could any one please give me the sample java code to solve this issue.

CREATE OR REPLACE PROCEDURE PROC1
 AS 
BEGIN 
SELECT AMOUNT INTO amnt FROM INVOICE WHERE INVOICE_NR = invoicenr; 
END;

Thanks & Regards
Krishnan