GBase8s数据库多结果集详解

# 1.环境准备

## 1.1 服务端

- 安装数据库
- 准备数据

```sql
# 创建测试表
create table tb1 (id int(10),name varchar(25));
create table tb2 (id int(10),name varchar(25));
# 测试数据
insert into tb1 values (1,"zs");
insert into tb2 values (1,"张三");
# 测试存储
#返回多个cursor类型
create or replace procedure test_two_cursor(rs1 out curosr,rs2 out cursor)
begin
open rs1 for select * from tb1;
open rs2 for select * from tb2;
end;

#返回不同类型
create or replace procedure test_two_out(rs1 out int(10),rs2 out varchar(25))
begin
select id，name into rs1，rs2 from tb1；
end;

#returning
create or replace procedure test_two_return() returning int(10),varchar(10)
begin
define rs1 int(10);
define rs2 varcahr(25);
rs1=1;
rs2="zs";
return rs1,rs2;
end;
```