RE: open/close cursor question

Hi Guang

> 16 select count(*) into cnt_cursor from v$open_cursor where =
sid=3D9;
> 17 dbms_output.put_line('1st time, before close cursor total =
number
> of open cursors =3D' || cnt_cursor );
> 18 CLOSE outmsg ;
> 19 dbms_output.put_line('1st time, after close cursor total =
number=20
> of open cursors =3D' || cnt_cursor );

The variable cnt_cursor cannot change between line 17 and 19. So, why do = you expect different values?

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l