Re: Why the SQL%ISOPEN return false ???

Hi,

From the book Oracle PL/SQL :

" The %ISOPEN attribute will always return FALSE - before and after the SQL statement. After the statement is executed, the implicit cursor will already have been opened and closed implicitly. An impicit cursor can never be open outside of the statement itself...."

So I wonder also - what for the command SQL%ISOPEN is?

Erika

yew.poo.choon_at_mbf.com.my wrote:
>
> 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 - 02:36:40 CDT