| |||||||||||||
Error message numbers...Error message numbers...Posted Oct 3, 2007 16:00 UTC (Wed) by hummassa (subscriber, #307)In reply to: Reviving linux-tiny by james Parent article: Reviving linux-tiny
are the salvation for anyone who has ever used Oracle. If you don't understand the short message, you just google for ORA.01234 or whatnot and voila -- tonnes of info about what, where and how the error often occurs.
(Log in to post comments)
Error message numbers... Posted Oct 3, 2007 16:07 UTC (Wed) by jengelh (subscriber, #33263) [Link] Well too bad if your only machine's network card driver quit its job.
Error message numbers... Posted Oct 3, 2007 16:25 UTC (Wed) by felixfix (subscriber, #242) [Link] Also too bad if you can't read the comment that suggests it be a compile time option, so only those who want to save the memory need enable it.
Error message numbers... Posted Oct 3, 2007 19:08 UTC (Wed) by nix (subscriber, #2304) [Link] Speaking as someone who uses Oracle every day, they're bloody awful. Ohlook, I got an ORA-xxyy complaining about some column in a big query. Which column? Oh, look, even though the RDBMS knows it refuses to tell me because there's no way to fit that into its precious bloody message number.
And so on.
I'd say that 25% of my error-message-revealed bug-fixing time is spent
[ot] sqlplus or oracle developer Posted Oct 22, 2007 23:32 UTC (Mon) by hummassa (subscriber, #307) [Link] use one of sqlplus or oracle developer to repeat your query, they usually mark the right spot where the error ocurred.
[ot] sqlplus or oracle developer Posted Oct 23, 2007 13:09 UTC (Tue) by nix (subscriber, #2304) [Link] Very amusing, well done. (they always mark *a* spot, often an entirely different one. I don't castigate them for this: parser error recovery is notoriously difficult. But the numbered-error-messages thing just makes everything so much harder than it should be...)
|
|||||||||||||