must use select ... into ... statemetn in oracle procudure
选择出来的数据没有地方存放,应该加上两个参数declare vstrName VARCHAR(32); v_strStartUserId tbUserArea.strStartUserId%TYPE; v_strEndUserId tbUserArea.strEndUserId%TYPE; begin vstrName :='aa'; SELECT strStartUserId,strEndUserId into v_strStartUserId ,v_strEndUserId from tbUserArea where nUsertype=0 and strName like '%vstrName%';end;
must use select ... into ... statemetn in oracle procudure
declare vstrName VARCHAR(32); str varchar2(100); begin vstrName :='aa'; str='SELECT strStartUserId,strEndUserId from tbUserArea where nUsertype=0 and strName like '''||vstrName||'%'''; execute immediate str ;end;
begin vstrName :='aa'; str='SELECT strStartUserId,strEndUserId from tbUserArea where nUsertype=0 and instr(strName,'||vstrName||')>0'; execute immediate str into v_strStartUserId ,v_strEndUserId; end; /
vstrName VARCHAR(32);
v_strStartUserId tbUserArea.strStartUserId%TYPE;
v_strEndUserId tbUserArea.strEndUserId%TYPE;
begin
vstrName :='aa'; SELECT strStartUserId,strEndUserId
into v_strStartUserId ,v_strEndUserId
from tbUserArea
where nUsertype=0
and strName like '%vstrName%';end;
vstrName VARCHAR(32);
str varchar2(100);
begin
vstrName :='aa'; str='SELECT strStartUserId,strEndUserId from tbUserArea where nUsertype=0 and strName like '''||vstrName||'%''';
execute immediate str ;end;
vstrName VARCHAR(32);
str varchar2(100);
v_strStartUserId tbUserArea.strStartUserId%TYPE;
v_strEndUserId tbUserArea.strEndUserId%TYPE;
begin
vstrName :='aa'; str='SELECT strStartUserId,strEndUserId from tbUserArea where nUsertype=0 and instr(strName,'||vstrName||')>0';
execute immediate str into v_strStartUserId ,v_strEndUserId;
end;
/