哪位老大指点一下,为何这个块在运行时,总报非法的零长度标识符?ORA-01741
declare
--variable define
V_item variable;
v_countnumber;
begin
select item_id into V_item
fromitem_person_xref
where item_person_xref.person_id='00128';
declare
--variable define
V_item variable;
v_count number;
v_record number;
begin
select count(*) into v_record from item_person_xref
where item_person_xref.person_id='00128';
if v_record>0 then
select item_id into V_item
from item_person_xref
where item_person_xref.person_id='00128';
if(V_item!=""
then v_count:=1
else v_count:=0;
DBMS_OUTPUT.put_line(V_item);
dbms_output.put_line(v_count);
end if;
end;