declare i number ; begin i := 2; pp(i); end;you can put DBMS_OUTPUT to debug your pp
各位大虾,我的过程如下,按照楼上老兄的方法,运行出错怎么办? create or replace procedure pp(recordno int) as sql_statement varchar2(500); i int ; begin
i := 0; while i <= recordno loop sql_statement :=' INSERT INTO EMP001 VALUES (' || i || ' ,''name'' ,''job'' ,100 , TO_DATE(''2002-10-16'', ''dd-Mon-yyyy HH:MI:SS AM'') ,100 ,100 ,100 )'; execute immediate sql_statement using recordno; i := i + 1;
end loop;
end;注意:过程建立是正确的
create or replace procedure pp(recordno int) as sql_statement varchar2(500); i int ; 改为 create or replace procedure pp(recordno int) as sql_statement varchar2; i int ;
i number ;
begin
i := 2;
pp(i);
end;you can put DBMS_OUTPUT to debug your pp
create or replace procedure pp(recordno int)
as
sql_statement varchar2(500);
i int ;
begin
i := 0;
while i <= recordno loop
sql_statement :=' INSERT INTO EMP001 VALUES (' || i || ' ,''name'' ,''job'' ,100 ,
TO_DATE(''2002-10-16'', ''dd-Mon-yyyy HH:MI:SS AM'') ,100 ,100 ,100 )';
execute immediate sql_statement using recordno;
i := i + 1;
end loop;
end;注意:过程建立是正确的
as
sql_statement varchar2(500);
i int ;
改为
create or replace procedure pp(recordno int)
as
sql_statement varchar2;
i int ;
而且还可以看到提示的错误信息
用这个工具,test一下,很好用的