Re: Can view$ be pinned ?

On Thu, 2 Dec 2004 11:37:37 +0100, Stephane Faroult <sfaroult_at_roughsea.com> 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