--测试存储过程 create or replace procedure sp_test( a in int,b in varchar2,c out int) is begin c:=a; end;--执行查询 select * from user_arguments where object_name=upper('sp_test');--查询结果SP_TEST SP_TEST 33682 A 1 1 0 NUMBER <Long> IN 22 38 10 INTEGER 0 0SP_TEST SP_TEST 33682 B 2 2 0 VARCHAR2 <Long> IN CHAR_CS VARCHAR2 BSP_TEST SP_TEST 33682 C 3 3 0 NUMBER <Long> OUT 22 38 10 INTEGER 0 0
为啥我的存储过程查不到 create or replace procedure get_elem(aa number) as begin select count(sid) into aa from student; end;
create or replace procedure sp_test( a in int,b in varchar2,c out int)
is
begin
c:=a;
end;--执行查询
select * from user_arguments where object_name=upper('sp_test');--查询结果SP_TEST SP_TEST 33682 A 1 1 0 NUMBER <Long> IN 22 38 10 INTEGER 0 0SP_TEST SP_TEST 33682 B 2 2 0 VARCHAR2 <Long> IN CHAR_CS VARCHAR2 BSP_TEST SP_TEST 33682 C 3 3 0 NUMBER <Long> OUT 22 38 10 INTEGER 0 0
create or replace procedure get_elem(aa number)
as
begin
select count(sid) into aa from student;
end;