Re: Can view$ be pinned ?

On Thu, 2 Dec 2004 11:37:37 +0100, Stephane Faroult
<sfaroult@xxxxxxxxxxxx> wrote (off list):
> 
> 
> Niall,
> 
>    I agree if you had
> 
>         today := SYSDATE;
> 
>  But I doubt that INSERT INTO BLAH VALUES (SYSDATE, ...);
> 
> generates any recursive SELECT FROM DUAL, in a trigger or anywhere else.
> 
> Regards, 
> 
> Stephane Faroult 

Apologies 

I was badly wrong with the version. I did some recollecting and this
came from Connor originally who states that it was fixed in 817.
helpfully he gives the bug reference
http://support.oracle.co.uk/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=BUG&p_id=1287775
 less helpfully it was fixed in 8.2 :(

My 9.2 reference was clearly daft. Almost certainly any 'supported'
versions are immune.


-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: