查询现有的存储过程包和生效与否
select owner,object_name,status from dba_objects where object_type=’PROCEDURE’;
查询某一存储过程包的源代码
select text from all_source a where a.name=’PROC_TEST’; PROC_TEST—存储过程包的名字
分配存储权限给另一用户
grant execute on 存储名 to 用户
执行存储过程
exec 存储名(参数)
存储过程例子
create or replace procedure testa(para1 in varchar2, para2 in varchar2)
AS
BEGIN
INSERT INTO TOM.TESTTB(ID,NAME) VALUES (PARA1,PARA2);
END;
create or replace procedure proc1
as
begin
for i in 1..10000
loop
execute immediate
'insert into t values(:x)' using i;
end loop;
end;