create or replace procedure insert_testuser(v_new_name IN varchar2(20))
is
v_name varchar2(20);
v_age number;
begin
v_name := v_new_name;
SELECT AGE INTO v_age from test_user where name = v_name;
end insert_testuser;报:PLS-00103错误,哪儿有问题???
is
v_name varchar2(20);
v_age number;
begin
v_name := v_new_name;
SELECT AGE INTO v_age from test_user where name = v_name;
end insert_testuser;报:PLS-00103错误,哪儿有问题???
is
v_name varchar2(20);
v_age number;
begin
v_name := v_new_name;
SELECT AGE INTO v_age from test_user where name = v_name;
end insert_testuser;
create or replace procedure insert_testuser(v_new_name IN varchar2)
建议下一本pl/sql编程的入门书籍,哪怕当作参考资料也好。