Re: Bug? Determining lengths of CLOB's in trigger/Oracle 8.1.7

On 21 Nov 2003 09:02:02 -0800, bbulsara23_at_hotmail.com (barry) wrote:

>I'd
>appreciate someone shining a light here if at all possible, or
>confirmation of the bug.

Likely the 'bug' consists of the combination of a 9i sqlloader connecting to a 8i database, and lousy trigger code. You shouldn't insert extra records in the table you are firing a trigger on, or you must at least make sure you use an autonomous transaction. I have the strange feeling when you just add an extra number column to the table, and manipulate the length column in a before insert trigger, as it should have been done in the first place, your so-called 'bug' disappears instantly.

--
Sybrand Bakker, Senior Oracle DBA