我的数据库,在加上 nowait SKIP LOCKED; 以后就会报错,如果不加就不会出错,环境为linux oracle C开发
EXEC SQL SELECT *
INTO :st_cert_reqdata
FROM tr_icreq WHERE pan= (select max( pan) from tr_icreq where flag='0' )
FOR UPDATE nowait SKIP LOCKED;
错误信息为:
Syntax error at line 53, column 98, file dbiccert.pc:
Error at line 53, column 98 in file dbiccert.pc
FROM tr_icreq WHERE pan= (select max( pan) from
tr_icreq where flag='0' ) FOR UPDATE NOWAIT SKIP LOCKED;
................................................................................
.................1
PCC-S-02201, Encountered the symbol "SKIP" when expecting one of the following: ; for, order,Syntax error at line 0, column 0, file dbiccert.pc:
EXEC SQL SELECT *
INTO :st_cert_reqdata
FROM tr_icreq WHERE pan= (select max( pan) from tr_icreq where flag='0' )
FOR UPDATE nowait SKIP LOCKED;
错误信息为:
Syntax error at line 53, column 98, file dbiccert.pc:
Error at line 53, column 98 in file dbiccert.pc
FROM tr_icreq WHERE pan= (select max( pan) from
tr_icreq where flag='0' ) FOR UPDATE NOWAIT SKIP LOCKED;
................................................................................
.................1
PCC-S-02201, Encountered the symbol "SKIP" when expecting one of the following: ; for, order,Syntax error at line 0, column 0, file dbiccert.pc:
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货