一个简单的存储过程：

create or replace procedure insert_user_procedure (id in number,name in varchar2,salary in number,result out varchar2) is begin insert into t_user values(id,name,salary); result:=‘调用存储过程成功‘; Exception when others then result:= ‘调用存储过程出错: ‘ || SQLERRM; end; call insert_user_procedure(?,?,?,?)

通过数据字典查询：

 select table_name from user_tables;//查询表 select sequence_name from user_sequences;//查询序列 select index_name from user_indexs;//查询索引