Re: Where is line 21?

ramon_at_conexus.net (Ramon F Herrera) wrote in message news:<c9bc36ff.0411141334.3499f5f5_at_posting.google.com>...
> 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?
>
> -Ramon

Hi, Ramon,

I did notice this anomaly before. Sometimes I just use the command 'nl myfile.sql' to look at non-blank lines (nl is a UNIX command). But I can't find consistency in my test.

Read Metalink notes 1010316.6 and 1050801.6. They may be outdated for your version. Tell us your version in any case.

Yong Huang Received on Mon Nov 15 2004 - 08:25:51 CST