create or replace procedure query_book is id number; begin select count(*) into id from people_manger; end query_book; /要有一个变量存放结果,我上面的也有问题。
create or replace procedure 过程名 is begin ...; end 过程名;
你用的是sql server的语法先别提问,起码看看oracle的过程语法再说呀 -- 大致结构如下create or replace procedure query_book (p_in number) is v_id number; begin select count(*) into v_id from people_manger where id = p_in; exception when sql_no_found then insert into table1(a) values (p_in); when others then null; end query_book; /
如果你什么变量都没有,那就可以直接这样: create or replace procedure aaa begin .....你的代码 end; /
create package test_age as type t_sor is ref cursor; end; / create or replace procedure query_book(p_rc out test_age.t_sor) is begin open p_rc for 'select * from people_manger'; end query_book; /
is
id number;
begin
select count(*) into id from people_manger;
end query_book;
/要有一个变量存放结果,我上面的也有问题。
is
begin
...;
end 过程名;
--
大致结构如下create or replace procedure query_book (p_in number)
is
v_id number;
begin
select count(*) into v_id from people_manger where id = p_in;
exception
when sql_no_found then
insert into table1(a) values (p_in);
when others then
null;
end query_book;
/
create or replace procedure aaa
begin
.....你的代码
end;
/
as
type t_sor is ref cursor;
end;
/
create or replace procedure query_book(p_rc out test_age.t_sor)
is
begin
open p_rc for 'select * from people_manger';
end query_book;
/