Getting value from stored procedure ??

[Em Aiy]

Hi,

I am calling a store procedure from Java, I am not sure how i'll recieve the value of the parameter with "OUT" tag in store procedure. Will, i receive this variable in Java as a result set, or it'll be stored in the variable which is used to when i was calling the store procedure.

sorry for English.

[Paul Sturrock]

CallableStatement cs = connection.prepareCall("{call myproc(?)}");
cs.registerOutParameter(1, Types.INTEGER);
cs.execute();
Integer outParamValue = cs.getInteger(1);     

(Don't apologize for your English - its good )
[ November 23, 2006: Message edited by: Paul Sturrock ]

[Em Aiy]

thanks paul, you saved my time for googling this code and thanks for praising english as well. ;)