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:

echo_on_051817

And when I ran the CREATE script again, setting ECHO on told me where to look:

where it is

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!

missing_comma_051817

Moral of the story:  ECHO ON can be your BFF on those days when you just can’t see clearly.

ADDENDUM!

Thanks to @thatjeffsmith for pointing out that there is a squiggle line in sql developer that indicates you have a problem nearby:

sqlDevTo the Rescue

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s