ORA-01480 trailing null missing from STR bind valueCause: A bind variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.Action: Terminate the string with a null character.
plsql中不用代码 程序里就用一般的update,将值封装在bean中
我也有类似的问题. procedure test(strtest in varchar2 default '') is begin execute IMMEDIATE strtest; end; 当strtest的长度超过2040时,就出现错误ORA-01480 trailing null missing from STR (STR 赋值变量缺少空后缀)
terminating null in its buffer.Action: Terminate the string with a null character.
程序里就用一般的update,将值封装在bean中
procedure test(strtest in varchar2 default '')
is
begin
execute IMMEDIATE strtest;
end;
当strtest的长度超过2040时,就出现错误ORA-01480 trailing null missing from STR (STR 赋值变量缺少空后缀)