"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3cb57158.1405105_at_news-vip.optusnet.com.au...
> Anyone here with 9.0.1.1 for NT installed on W2K?
>
> Please do the following:
>
> Go to SQL*Plus and type:
> set pause on pause 'Press Return to continue...'
> then do:
> select * from dual;
>
> Tell me what happens to your session.
>
> Mine vanishes. In three boxes now. All Win2K Pro, all 9i default
> install, all P4s.
> WTF?
looks like a bug to me. happens on my workstation win2ksp2 NOT a P4.
It also kills connections to 8i databases so I suggest its a sqlplus9i bug.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
>
>
> Also, a bone to pick ewith Mr. Oracle:
>
> We were told that SQL and PL/SQL now had the same parser.
>
> OK, says I: I can now use SQL conditions in my PL/SQL IF statement.
> So I go to SQL manual and check out what are all possible conditions.
> Then I try in a PL/SQL block:
>
> if (colmna in ('A','B','C') then
> etc,etc.
> It works. It also worked in 8i.
>
> if (colmna like 'A%') then
> etc,etc.
> It works. It also worked in 8i.
>
> if (exists (select 1 from dual)) then
> etc,etc.
> Bang, goes the syntax checker. Also in 8i, of course.
>
> So, when is a SQL condition not parsed the same in PL/SQL?
>
> Hmmmmmmm?
>
>
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Thu Apr 11 2002 - 07:44:42 CDT
