PL/SQL的矛盾!PL/SQL开发高手请进!
declare
ls_Hesxl varchar2(255):='';
begin
.../*这里一系列的PL/SQL语句,使得ls_Hesxl=('0925','0867','0035')*/
declare
CURSOR cur_KePLX_DL IS
select distinct keplx,piaoj,xianldm from aaa where xianldm in ls_Hesxl;
begin
.../*一系列的SQL语句*/
end;
end;
CURSOR cur_KePLX_DL IS
select distinct keplx,piaoj,xianldm from aaa where xianldm in ls_Hesxl这一句根本行不通,为什么呢?该怎么解决呢?
PL/SQL在declare申明块里不能写实现语句,在begin end;实现语句里不能写申明语句,实现太笨了!