下图是在Pgadmin4中运行显示

这个语法不对，不能直接用Oracle的，创建示例如下：

create [or replace] procedure procedure_name(parameter_list)
language plpgsql
as $$
declare
-- variable declaration
begin
-- stored procedure body
end; $$
复制

create or replace procedure stu_proc1 (pno in student.sno%type)
as $$
declare
    pname text;
begin
    select sname into pname from student where sno=pno;
	raise notice ' %',pname;
end;
$$ language plpgsql;
复制