用下面的过程也出现上面的错误!
过程创建是成功的
Create or replace procedure p_test
IS
Cursor c_cemp IS Select * from NET_INFO;
r_emp c_cemp%ROWTYPE;
Begin
open c_cemp;
loop
fetch c_cemp into r_emp;
exit when c_cemp%NOTFOUND;
end loop;
close c_cemp;
End p_test;
过程创建是成功的
Create or replace procedure p_test
IS
Cursor c_cemp IS Select * from NET_INFO;
r_emp c_cemp%ROWTYPE;
Begin
open c_cemp;
loop
fetch c_cemp into r_emp;
exit when c_cemp%NOTFOUND;
end loop;
close c_cemp;
End p_test;
query.sql.add(select * from pkg_test.p_test');
query.open;
query.close;
query.sql.add('select * from pkg_test.p_test()');
query.open;
唉,