create or replace procedure peace_exp(in1 in VARCHAR2)
is
c_n varchar2(100);
begin
select NAME into c_n from a where a.id = in1;
dbms_output.put_line(c_n);
exception
when no_data_found
then
dbms_output.put_line('try');
when TOO_MANY_ROWS
then
dbms_output.put_line('more');
end;命令窗口 exec peace_exp(1); 还是看不到效果呢 怎么看到结果呢 dbms_output.put_line('more');
end;
a表结构-- Create table
create table A
(
ID NUMBER,
AGE NUMBER,
NAME VARCHAR2(11),
TIME DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
is
c_n varchar2(100);
begin
select NAME into c_n from a where a.id = in1;
dbms_output.put_line(c_n);
exception
when no_data_found
then
dbms_output.put_line('try');
when TOO_MANY_ROWS
then
dbms_output.put_line('more');
end;命令窗口 exec peace_exp(1); 还是看不到效果呢 怎么看到结果呢 dbms_output.put_line('more');
end;
a表结构-- Create table
create table A
(
ID NUMBER,
AGE NUMBER,
NAME VARCHAR2(11),
TIME DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
set serverout on
exec peace_exp(1);