create or replace type USERSEQID_ARRAY AS VARRAY(32) of varchar(32);
CREATE OR REPLACE TYPE USERNAME_ARRAY AS VARRAY(32) of varchar(32);create or replace procedure make_logincard_pro (
p_cardsuitcode in varchar,
p_userseqidArr out USERSEQID_ARRAY ,
p_usernameArr out USERNAME_ARRAY
)
AS
BEGIN
FOR i in 1.. 10 LOOP
IF p_userseqidArr IS NULL THEN
p_userseqidArr := USERSEQID_ARRAY(i);
ELSE
p_userseqidArr.Extend;
p_userseqidArr(i) :=i;
END IF; IF p_usernameArr IS NULL THEN
p_usernameArr := USERNAME_ARRAY(i || 'TT');
ELSE
p_usernameArr.Extend;
p_usernameArr(i) :=i || 'TT';
END IF;
END LOOP;END;declare
a_varlist USERSEQID_ARRAY;
b_varlist USERNAME_ARRAY;
begin
make_logincard_pro('AA',:a_varlist,:b_varlist);
end;
总是报ORA-01008:not all variables bound
各位大侠帮忙看看,谢谢
CREATE OR REPLACE TYPE USERNAME_ARRAY AS VARRAY(32) of varchar(32);create or replace procedure make_logincard_pro (
p_cardsuitcode in varchar,
p_userseqidArr out USERSEQID_ARRAY ,
p_usernameArr out USERNAME_ARRAY
)
AS
BEGIN
FOR i in 1.. 10 LOOP
IF p_userseqidArr IS NULL THEN
p_userseqidArr := USERSEQID_ARRAY(i);
ELSE
p_userseqidArr.Extend;
p_userseqidArr(i) :=i;
END IF; IF p_usernameArr IS NULL THEN
p_usernameArr := USERNAME_ARRAY(i || 'TT');
ELSE
p_usernameArr.Extend;
p_usernameArr(i) :=i || 'TT';
END IF;
END LOOP;END;declare
a_varlist USERSEQID_ARRAY;
b_varlist USERNAME_ARRAY;
begin
make_logincard_pro('AA',:a_varlist,:b_varlist);
end;
总是报ORA-01008:not all variables bound
各位大侠帮忙看看,谢谢
解决方案 »
- power designer生成view的问题
- 数据仓库 设计
- Oracle 怎样在已存在的表上建立复合分区?
- 简单sql
- 这样在unix server 下查看 server 上装的Oracle 版本号
- 关于个SQL语句
- 如果修改oracle中日期类型的默认格式 (按以前的方法不行)
- 数据库的字段数多少会不会对写数据库的速度造成影响
- 怎么样查数据库当前在处理以及将要处理的语句?
- oracle8i中有毫秒吗?oracle9i中timestamp是带毫秒的,那8i中怎么表示毫秒呢?谢谢
- [Oracle/基础和管理]请问OCIStmtPrepare中的语句长度要不要加上“\0”呢?
- 请问使用SQLLDR导入多行记录
declare
a_varlist USERSEQID_ARRAY;
b_varlist USERNAME_ARRAY;
begin
make_logincard_pro('AA',a_varlist,b_varlist);
end;