search

tanelpoder / tpt-oracle

Tanel Poder's Performance & Troubleshooting Tools for Oracle Databases
https://tanelpoder.com
Other
657 stars 312 forks source link

sql_id.sql throws sqlplus-error #13

Closed nklamann closed 5 years ago

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

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

tanelpoder commented 5 years ago

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

nklamann commented 5 years ago

SQLDveleoper 19.x , it wasa column CH#

nklamann commented 5 years ago

I created PR #14 for this

tanelpoder commented 5 years ago

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!

nklamann commented 5 years ago

I created SR 3-21464161261 for this

tanelpoder commented 5 years ago

Thanks!

nklamann commented 5 years ago

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