I am on the look out for a way to pass parameters  to a stored
procedure using their names as defined  in the stored  procedure.

java.sql.Statement 's .execute() should be called after the parameters
are set. But the problem  lies in the previous step. I'll elaborate --

As I mentioned in previous mail following command works in Query Analyser.
" exec  update_costing_table @costing_code='4001' "

In java  I can achieve above result as under --
PreparedStatement pstmt =
connection.prepareStatement("call update_costing_table (?)");
pstmt.setString(1,"4001");
pstmt.executeUpdate();

But here parameter  is passed  using column Index not by column name.
And I precisely need to do it using column name only.