Tip for Newbies! (Or oldies that just can’t see)
Don’t you hate it when you’re running a REALLY simple script, and you get an Oracle error – and you just can’t see the issue? Like today – I am just running a simple little CREATE TABLE and I keep bombing – and I KNOW it’s something stupid like a missing comma or misplaced parenthesis, but I just couldn’t see where it was.
Error report –
ORA-00907: missing right parenthesis
So I tossed in this:
And when I ran the CREATE script again, setting ECHO on told me where to look:
And wouldn’t you know it – MISSING COMMA! Not a missing parenthesis – as the error would have you think – but it still points you in the right direction. Right around line 13 ..but I sure couldn’t see it before even though I looked up and down my lines of code and even have color-coding set on my text editor!
Moral of the story: ECHO ON can be your BFF on those days when you just can’t see clearly.
Thanks to @thatjeffsmith for pointing out that there is a squiggle line in sql developer that indicates you have a problem nearby:
I’d probably seen that squiggle a million times and never noticed it before. EVER.
This is what’s great about working in I.T. – you can learn something new everyday, from really smart people.