On 14 Nov 2004, ramon_at_conexus.net wrote:
> Hello:
>
> I keep on getting error messages like the following:
>
> ------------------
> Record 7: Rejected - Error on table SHAWS. ORA-00001: unique
> constraint (DATABASE.CACHE) violated ORA-06512: at
> "DATABASE.SYNCSHAWS", line 21 ORA-04088: error during execution
> of trigger 'DATABASE.SYNCSHAWS' -------------------
>
> However, when I take a look at the file that contains
> the SQL/PL code (in this case, a trigger) line 21 doesn't
> seem to be the right line. Is there some sort of magic
> delta number to be added/substracted?
> Perhaps I should remove the empty lines in my source code
> and count again?
Make sure you count from the "create or replace" and not the top
of the file. Still might only get you close.
--
Galen Boyer
Received on Sun Nov 14 2004 - 21:09:15 CST
