不需要参数,就把括号去掉, CREATE OR REPLACE FUNCTION Checktest RETURN varchar2 IS 2 v_name varchar2(200); 3 cursor c_test is select ID, NAME, JOB from test; 4 begin 5 for a in c_test loop 6 v_name:=v_name||' - '||a.ID||' - '||a.NAME||' - '||a.JOB; 7 end loop; 8 dbms_output.put_line(v_name); 9 RETURN v_name; 10 END Checktest;
CREATE OR REPLACE FUNCTION Checktest
RETURN varchar2 IS
2 v_name varchar2(200);
3 cursor c_test is select ID, NAME, JOB from test;
4 begin
5 for a in c_test loop
6 v_name:=v_name||' - '||a.ID||' - '||a.NAME||' - '||a.JOB;
7 end loop;
8 dbms_output.put_line(v_name);
9 RETURN v_name;
10 END Checktest;