java.sql.SQLException: ORA-00911: invalid character :
在SQL语句后面有; 号或 其他字符,去掉 ; 或者注释 。
java.sql.SQLException: ORA-01400: cannot insert NULL into ("GSF"."HCYPVSL"."VSLVSL")
空字符,无法执行语句,添上数据。
java.sql.SQLException: ORA-12899:
超出最大值 ,减小变量值
PLS-00306: wrong number or types of arguments in call to
PL/SQL 传递和接受的参数不一致
ORA-01403: no data found
SELECT .. INTO 时没有查询的ROW 。SELECT NVL(MAX(GLGIOS),0) INTO v_GATESEQ FROM HCYPGLG WHERE GLGDPT=v_CYCODE AND GLGIOD=v_GATEDATE;