open c_mycursor for 'select * from t1'; fetch c_mycursor into tmpuser,tmppwd,tmptext; loop
insert into t2 ............. ............. exit when c_mycursor%notfound; end loop; close c_mycursor;修改以下,看情况如何? insert into t2 (muser,mpwd) (select * from t1); 若不行,把它改成动态,应该没问题。
fetch c_mycursor into tmpuser,tmppwd,tmptext;
loop
insert into t2 .............
.............
exit when c_mycursor%notfound;
end loop;
close c_mycursor;修改以下,看情况如何?
insert into t2 (muser,mpwd) (select * from t1);
若不行,把它改成动态,应该没问题。