create or replace PROCEDURE SP_Materials(
   ITEM_ID IN VARCHAR2,
   ITEM_DESC OUT VARCHAR2
)AS
BEGIN
     IF (ITEM_ID = '01') THEN
        ITEM_DESC := 'Hammer';
     END IF;
     IF(ITEM_ID = '02') THEN
        ITEM_DESC := 'Nail';
     END IF;
END SP_Materials;

try {
        CallableStatement callableStatementReturn = null;
        String callableStatement = "{call SP_Materials(?,?)}";
        Connection dbConn =
            DriverManager.getConnection("jdbc:oracle:thin:@10.20.30.40:1111:SID1", "user", "pass");
        callableStatementReturn = dbConn.prepareCall(callableStatement);
        callableStatementReturn.setString(1, "01");
        callableStatementReturn.registerOutParameter(2, java.sql.Types.VARCHAR,1000);
        callableStatementReturn.executeQuery();

        System.out.println( callableStatementReturn.getCharacterStream(2).read());

    } catch (Exception e) {
        e.printStackTrace();
    }