CREATE OR REPLACE procedure show_line(ip_line_length in number,ip_separator in varchar2)
actual_line varchar2(150);
begin
for idx in 1..ip_line_length loop
actual_line :=actual_line ||ip_separator;
end loop;
dbms_output.put_line(actual_line);
exception when others then
-- dbms_output.put_line(sqlerrm);
end;
actual_line varchar2(150);
begin
for idx in 1..ip_line_length loop
actual_line :=actual_line ||ip_separator;
end loop;
dbms_output.put_line(actual_line);
exception when others then
-- dbms_output.put_line(sqlerrm);
end;
create or replace procedure show_line(ip_line_length in number,ip_separator in varchar2)
as
actual_line varchar2(150);begin
for idx in 1..ip_line_length loop
actual_line :=actual_line ||ip_separator;
end loop;
dbms_output.put_line(actual_line);
exception when others then
null;
end;你有exception 就不應該把dbms_output.put_line(sqlerrm); 注釋掉
知道不
is actual_line varchar2(150);
begin
for idx in 1..ip_line_length loop
actual_line :=actual_line ||ip_separator;
end loop;
dbms_output.put_line(actual_line);
end;
AS
actual_line varchar2(150);
begin
for idx in 1..ip_line_length loop
actual_line :=actual_line ||ip_separator;
end loop;
dbms_output.put_line(actual_line);
exception when others then
dbms_output.put_line(sqlerrm);
end;