在ALTIBASE内存数据库iSQL工具中创建\执行存储过程如下:
iSQL> show user
User : SYS
iSQL> create or replace procedure inst_tab_1_proc
2 (p1 in integer,p2 in char(10))
3 as
4 begin
5 insert into tab_1 (id,name) values (p1,p2);
6 end;
7 /
Create success.
iSQL> select * from tab_1;
TAB_1.ID TAB_1.NAME
---------------------------
1 wangxiao
2 zhangsan
3 lisi
3 rows selected.
iSQL> var id integer
iSQL> var name char(10)
iSQL> execute :id:=4;
Execute success.
iSQL> execute :name:='wangqiang';
Execute success.
iSQL> execute inst_tab_1_proc (:id,:name);
Execute success.
iSQL> select * from tab_1;
TAB_1.ID TAB_1.NAME
---------------------------
1 wangxiao
2 zhangsan
3 lisi
4 wangqiang
4 rows selected.
iSQL> show user
User : SYS
iSQL> create or replace procedure inst_tab_1_proc
2 (p1 in integer,p2 in char(10))
3 as
4 begin
5 insert into tab_1 (id,name) values (p1,p2);
6 end;
7 /
Create success.
iSQL> select * from tab_1;
TAB_1.ID TAB_1.NAME
---------------------------
1 wangxiao
2 zhangsan
3 lisi
3 rows selected.
iSQL> var id integer
iSQL> var name char(10)
iSQL> execute :id:=4;
Execute success.
iSQL> execute :name:='wangqiang';
Execute success.
iSQL> execute inst_tab_1_proc (:id,:name);
Execute success.
iSQL> select * from tab_1;
TAB_1.ID TAB_1.NAME
---------------------------
1 wangxiao
2 zhangsan
3 lisi
4 wangqiang
4 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10954452/viewspace-606836/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10954452/viewspace-606836/