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.

Advertisements

About Helen J. Sanders

Assistant Director, Applications Development Services in the Student Collaboration Center at Temple University. Oracle database developer and enthusiast. Active in ODTUG. Serving on the Board of Directors for the Temple University Alumni Association, the Temple College of Education Alumni Association, and Vice President of the Network of Women with Careers in Technology.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: