create or replace procedure batchInsertCompanyRole as
Cursor companyIdCursor is select company_id from(select count(*) num,company_id from platform_role t group by company_id) where num=1;
companyId varchar2(32);
begin
for companyId in companyIdCursor loop
begin
dbms_output.put_line(companyId);
end;
end loop;
end batchInsertCompanyRole;报错:wrong number or types of arguments in call to 'put_line'
Cursor companyIdCursor is select company_id from(select count(*) num,company_id from platform_role t group by company_id) where num=1;
companyId varchar2(32);
begin
for companyId in companyIdCursor loop
begin
dbms_output.put_line(companyId);
end;
end loop;
end batchInsertCompanyRole;报错:wrong number or types of arguments in call to 'put_line'
解决方案 »
- 求select写法 oracle 11g(PLSQL)
- 求助 oracle用户对表的操作权限问题
- oracle 10g到10g imp 导入数据出错 求高手分析
- oracle 时间类型
- 高人帮忙看个牛的存贮过程更新出现错误问题!!!!!
- 求:oracle md5 函数及用法
- 如何设定视图的superview_name ?
- oracle中不能直接使用如下的语句吗?(条件中不能直接使用pl/sql语句?)
- 请问如何启动OracleOraHome92Agent?
- 关于分区表的问题
- 建了一个DML触发器,插入数据的时候触发,操作时报错,求解答。。。
- PL/SQL: Statement ignored的问题
Cursor companyIdCursor is select company_id cid from(select count(*) num,company_id from platform_role t group by company_id) where num=1;
companyId varchar2(32);
begin
for companyId in companyIdCursor loop
begin
dbms_output.put_line(companyId.cid);
end;
end loop;
end batchInsertCompanyRole;