CREATE or replace PROCEDURE "SYSTEM"."TESTPROC" (sname IN VARCHAR2) as BEGIN update ONLYTEST set age = '0' where rtrim(name) = sname; commit; END; --这样行不行
create table onlytest(name varchar2(20),age number);CREATE or replace PROCEDURE TESTPROC (sname IN VARCHAR2) as BEGIN update ONLYTEST set age = '0' where name = sname; END;没有问题. 你用show error看看什么错.
BEGIN
update ONLYTEST set age = '0' where rtrim(name) = sname;
commit;
END;
--这样行不行
BEGIN
update ONLYTEST
set age = '0'
where name = sname;
END;没有问题. 你用show error看看什么错.
ORA-00XXX????