Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why the SQL%ISOPEN return false ???
can anyone explain to me whay the follow PL/SQL block return me a
FALSE value for variable v_result ?
Thank you
declare
v_result boolean;
name varchar2(35);
begin
select first_name into name
from employee
where first_name ='TEST';
v_result := SQL%ISOPEN;
if v_result then
insert into testing values ('v_result is true'); else
insert into testing values ('v_result is false');
end if;
commit;
end;
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 08 1999 - 00:12:35 CDT