try {
            conn = WmsDBConnUtils.getConnection(broker);
            conn.setAutoCommit(false);
 state = conn.prepareCall("{call Wms_Admin.GROUP_ROLES_TRANSFER(?,?,?)}");
            state.setString(1, tmId);
            state.setString(2, bmId);
            state.setString(3, lastUpdatedBy);
 }catch (SQLException ex) {
            log.error(ex, ex);
            try {
                if (conn != null)
                    conn.rollback();
            }
            catch (SQLException ex2) {
                log.warn(ex2, ex2);
            }
            throw ExceptionUtils.getRemoteException(ex.getMessage(), ex);
        }
        catch (LookupException ex) {
            log.error(ex, ex);
            try {
                if (conn != null)
                    conn.rollback();
            }
            catch (SQLException ex2) {
                log.warn(ex2, ex2);
            }
            throw ExceptionUtils.getRemoteException(ex.getMessage(), ex);
        }
        catch (Exception ex) {
            log.error(ex, ex);
            throw ExceptionUtils.getRemoteException(ex);
        }
        finally {
            try {
                if (conn != null)
               
                    conn.close();
            }
            catch (Exception ex) {
                log.warn(ex, ex);
            }
            OJBUtils.closeBroker(broker);
        }
存储过程
procedure GROUP_ROLES_TRANSFER(
    pTmId in WMS_USER.USER_ID%type,
    pBmId in WMS_USER.USER_ID%type,
    pOperator in WMS_USER.LAST_UPDATED_BY%type
    )is
    begin 
    SET TRANSACTION READ WRITE;
    update wms_user set parent_id = 'ETWODC',last_updated_by = pOperator, last_updated_time =SYSDATE where parent_id=pTmId;
   
 
    update wms_user set parent_id = null,last_updated_by = pOperator, last_updated_time =SYSDATE  where user_id=pTmId;
       update wms_user set parent_id = pTmId,last_updated_by = pOperator, last_updated_time =SYSDATE where parent_id=pBmId;
       update wms_user_role set role_id = 'BM',last_updated_by = pOperator, last_updated_time =SYSDATE  where user_id=pTmId;
  
    update wms_user_role set role_id = 'TM',last_updated_by = pOperator, last_updated_time =SYSDATE  where user_id=pBmId;
       update wms_user set parent_id = pTmId,last_updated_by = pOperator, last_updated_time =SYSDATE where user_id=pBmId;
        update wms_user set parent_id = pBmId,last_updated_by = pOperator, last_updated_time =SYSDATE where parent_id='ETWODC';
    COMMIT;
    end GROUP_ROLES_TRANSFER;

为什么运行不成功呀，希望那个高手帮一下忙嘛，谢谢