11:52:59 SQL> create table t1(a int,b int);表已创建。已用时间: 00: 00: 00.16
11:53:03 SQL> create or replace procedure tes(a in integer,b in integer)
11:53:05 2 as
11:53:05 3 begin
11:53:05 4 insert into t1 values (a,b);
11:53:05 5 commit;
11:53:05 6 end;
11:53:05 7 /过程已创建。已用时间: 00: 00: 00.31
11:53:06 SQL> exec tes(3,4)PL/SQL 过程已成功完成。已用时间: 00: 00: 00.16
11:53:12 SQL> select * from t1; A B
---------- ----------
3 4已用时间: 00: 00: 00.00
11:53:03 SQL> create or replace procedure tes(a in integer,b in integer)
11:53:05 2 as
11:53:05 3 begin
11:53:05 4 insert into t1 values (a,b);
11:53:05 5 commit;
11:53:05 6 end;
11:53:05 7 /过程已创建。已用时间: 00: 00: 00.31
11:53:06 SQL> exec tes(3,4)PL/SQL 过程已成功完成。已用时间: 00: 00: 00.16
11:53:12 SQL> select * from t1; A B
---------- ----------
3 4已用时间: 00: 00: 00.00
INSERT INTO init_switch_ta (switchname,state,initenvindex)
VALUES (:ck_name,:ck_state,:bs_init_index);
EXEC SQL AT :db_name OPEN pt4;---〉
EXEC SQL AT :db_name INSERT INTO init_switch_ta (switchname,state,initenvindex)
VALUES (:ck_name,:ck_state,:bs_init_index);