create or replace procedure up_test2(stuid in number)
as
varname varchar2(20);
begin
select stuname into varname from test where id=stuid;
dbms_output.put_line(varname);
end up_test2;
执行该存储过程:
exec up_test2(2);
请问是什么问题?
...全文
5316打赏收藏
提示无效的sql语句, 请问是怎么回事?
oracle数据库,创建了一个存储过程,如下: create or replace procedure up_test2(stuid in number) as varname varchar2(20); begin select stuname into varname from test where id=stuid; dbms_output.put_line(varname); end up_test2; 执行该存储过程: exec up_test2(2); 请问是什么问题?