sql_id.sql throws sqlplus-error

Question

sql_id.sql throws sqlplus-error

nklamann opened this issue 5 years ago · 8 comments

nklamann commented 5 years ago

Due to wrong Column Header. This should be enclosed in ". I can provide a pull request

tanelpoder commented 5 years ago

Thanks!

Answer 1 · 2019-11-01T01:18:55.000Z

Please do. Which version are you using, sqlid.sql doesn't throw errors in my env ...

Answer 2 · 2019-11-01T01:19:33.000Z

I mean which sqlplus version (I assume there's a sqlplus error, not DB error)

Answer 3 · 2019-11-01T11:51:46.000Z

SQLDveleoper 19.x , it wasa column CH#

Answer 4 · 2019-11-01T11:55:06.000Z

I created PR #14 for this

Answer 5 · 2019-11-04T02:04:10.000Z

Ok so it wasn't a sqlplus error, but SQL Developer error. Yep I've found SQL Developer not liking # in the column names for some reason (should actually raise this with SQL Dev dev team, they're quick to fix things). Thanks for the PR!

Answer 6 · 2019-11-04T07:08:42.000Z

I created SR 3-21464161261 for this

Answer 7 · 2019-11-12T12:06:03.000Z

Following bug has been created.Bug 30531514 - SP2-0158: UNKNOWN COLUMN OPTION WHEN USING SPECIAL CHARACTER FOR COLUMN HEADING AT SQL DEVELOPER WORKSHEET