select .... into...
这样才好。
这样才好。
解决方案 »
- 关于oracle sequence步长 为1 但实际上显示的步长是2 求解释
- 启动 Database Control 时出错
- oracle(11g)在Linux下怎么安装
- 关于oracle数据库sql语句全角半角问题
- LogMiner分析Oracle数据库日志文件生成字典文件问题
- Oracle 列名总是自动变成大写???
- [求] 求Oracle817打补丁的过程及如何取得补丁!谢谢!!
- 如果表结构已经有了,如何从一个大的exp后的dmp文件中导入某张(些)表的数据?
- user_view视图的问题
- oracle 插入数据不成功报错
- 很难的问题,很少有人做的出的,请大家帮帮忙!
- 用 c++ builder 6.0 能编译pro*c/c++ 的程序吗?
(v_pc in varchar2,
v_date in date,
v_dateq in date,
v_jdjm in varchar2)
is
jz jz_ffyjkbak%rowtype;//定义变量
begin
if v_pc='1' then
select * into jz from jz_ffyjkbak
where (jz_date = v_date or (jz_date = v_dateq and jz_time like '2%')) and (pc_hao='1')
and (jz_jdjm=(select name_c from jz_jzjm where name_e = v_jdjm));
else
select * into jz from jz_ffyjkbak
where (jz_date = v_date) and (pc_hao = v_pc and jz_jdjm=(select name_c from jz_jzjm where name_e = v_jdjm));
end if;
end;
/
CREATE or replace procedure jz_getyj
(v_pc in varchar2,
v_date in date,
v_dateq in date,
v_jdjm in varchar2)
cursor getyj is
select jz_yjhm,jz_zbhm,jz_yjyjjm from jz_ffyjkbak
where (jz_date = v_date or (jz_date = v_dateq and jz_time like '2%')) and (pc_hao='1')
and (jz_jdjm=(select name_c from jz_jzjm where name_e = v_jdjm));
cursor getyj1 is
select jz_yjhm,jz_zbhm,jz_yjyjjm from jz_ffyjkbak
where (jz_date = v_date) and (pc_hao = v_pc and jz_jdjm=(select name_c from jz_jzjm where name_e = v_jdjm));
is
yjhm varchar2;
zbhm varchar2;
yjyjjm varchar2;
begin
if v_pc='1' then
open getyj;
loop
fetch getyj into yjhm,zbhm,yjyjjm;
dbms_output.put_line(yjhm,zbhm,yjyjjm);
end loop;
close geryj;
end if;
if v_pc<>'1' then
open getyj1;
loop
fetch getyj into yjhm,zbhm,yjyjjm;
dbms_output.put_line(yjhm,zbhm,yjyjjm);
end loop;
close getyj1;
end if;
end;
ERROR 位于第1行:
ORA-06550: 第 1 行, 第 25 列:
PLS-00357: 在此上下文中不允许表,视图或序列引用 'CLASSES'
ORA-06550: 第 1 行, 第 25 列:
PL/SQL: Statement ignored