Re: Can view$ be pinned ?
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: sfaroult@xxxxxxxxxxxx, "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Dec 2004 23:24:34 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
