哈哈__哈哈的专栏

第一个简单的存储过程：create or replace procedure update_sal(id number, name varchar2) isv_sqlcode number;v_sqlerrm varchar(1000);begin insert into testa (id, name) values (id, name); commit;exce...

用SQL命令行：job:variable job number;begin sys.dbms_job.submit(job => :job, what => 'clearseq(''SEQ_SN_ID'');', next_date => to_date('16-10-2...

直接上代码： 是在包里写的存储过程，要测试的话，要先写声明  声明procedure test1(p_RETCODE in out varchar2, p_retInfo in out varchar2); procedure test2(p_RETCODE in out varchar2, p_retInfo in out varchar2); procedure t...

没研究出来oracle exception的传播  procedure test1(p_RETCODE in out varchar2, p_retInfo in out varchar2); procedure test2(p_RETCODE in out varchar2, p_retInfo in out varchar2); procedure test3(p_RET...