SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Do pl/sql error message line numbers mean anything?

561854Mar 25 2008 — edited Mar 26 2008

I'm trying to debug a large pl/sql procedure and I'm really frustrated by the poor error messages generated by the parser. In general, the messages are useless for locating an error. The most useless of all parser output seems to be the line number of an error. I can see no correspondence between my source file and the line numbers generated. For example, I added a line, at line 36, without a concluding semi-colon. The error message referenced line 8 column 1. The added line is not line 8 in the file or line 8 in any function or procedure or line 8 in anything if I subtract the comment and blank lines.

Is there a way to interpret the line numbers that make them useful for locating errors?

-=beeky

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2008

Added on Mar 25 2008

15 comments

3,192 views