超过递归 SQL(50)级的最大值的错误帮忙看看 有源码？？

Question

能否贴出 CAR_INFO 的建表语句

Answer 1

CAR_INFO表以前是手动一个一个加的
我刚才试了下 手动添加数据 也不行啊 出现同样错误

Answer 2

把CAR_INFO 表的字段类型贴出来，需要测试一下

Answer 3

create table CAR_INFO
(
  CARID                NUMBER(10) not null,
  CAR_CLASS            VARCHAR2(2) not null,
  CAR_MARK             VARCHAR2(20),
  CARMARK_TYPE         VARCHAR2(1),
  GSM_NUMBER           VARCHAR2(11),
  MOTORID              VARCHAR2(30),
  UNDERPANID           VARCHAR2(30),
  TAXINO               VARCHAR2(20),
  CAR_COLOR            VARCHAR2(10),
  CAR_TYPE             VARCHAR2(20),
  TELEPHONE            VARCHAR2(20),
  CAR_MARK2            VARCHAR2(20),
  COMPANYID            NUMBER(10),
  COMPANY_SID          VARCHAR2(20),
  MOTORCADE            VARCHAR2(20),
  PHOTO                VARCHAR2(100),
  BUYDAY               VARCHAR2(10),
  BUYPAY               NUMBER(20,2),
  PRODUCE_COMPANY      VARCHAR2(100),
  REGIST_DAY           NVARCHAR2(10),
  RUNNO                VARCHAR2(60),
  RUNCARD_DAY          VARCHAR2(10),
  RUNCARD_PVALID       VARCHAR2(10),
  INVOICE              VARCHAR2(20),
  REMARK               VARCHAR2(1000),
  SERCHKEY             VARCHAR2(1000),
  RESV1                VARCHAR2(100),
  RESV2                VARCHAR2(100),
  RESV3                VARCHAR2(100),
  RESV4                VARCHAR2(100),
  RESV5                VARCHAR2(100),
  RESV6                VARCHAR2(100),
  RESV7                VARCHAR2(100),
  RESV8                VARCHAR2(100),
  RESV9                VARCHAR2(100),
  RESV10               VARCHAR2(100),
  CAR_STATUS           VARCHAR2(1) default 1,
  LAST_LON             NUMBER(15,4),
  LAST_LAT             NUMBER(15,4),
  LAST_SPEED           NUMBER(10,1),
  LAST_ANGLE           NUMBER(10,1),
  LAST_TIME            VARCHAR2(20),
  LAST_FLAG            NUMBER(10),
  LAST_UPDATE_TIME     VARCHAR2(40),
  LAST_NALERMTYPE      VARCHAR2(10),
  LAST_STATUS          VARCHAR2(50),
  COMM_COMPANYID       NUMBER(15),
  MONITORING_FREQUENCY VARCHAR2(10),
  OVERSPEED_VALUE      VARCHAR2(10),
  EMPTY_FREQUENCY      VARCHAR2(10),
  WEIGHT_FREQUENCY     VARCHAR2(10),
  BALE_NAME            VARCHAR2(50),
  CAR_TONNAGE          VARCHAR2(20),
  SUPERCARGO_NAME      VARCHAR2(10),
  OPERATE_CARD         VARCHAR2(20)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 80K
    minextents 1
    maxextents unlimited
  );

Answer 4

把CAR.Currval 替换为
AR.NEXTVAL 试试