SKIP LOCKED 出错
我的数据库,在加上 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: