Bug 187729 - Use of # in SQL command Editor throws an exception
Use of # in SQL command Editor throws an exception
Status: NEW
Product: serverplugins
Classification: Unclassified
Component: OC4J
6.x
All Windows XP
: P1 (vote)
: TBD
Assigned To: Michal Mocnak
issues@serverplugins
: PLATFORM
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-06-17 13:19 UTC by sandy1264
Modified: 2011-11-16 16:34 UTC (History)
0 users

See Also:
Issue Type: DEFECT
:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description sandy1264 2010-06-17 13:19:11 UTC
I have setup my database connection for oracle and logged in to database server.

Now if i try to fetch the data from a table using a column name which has '#' character in it. It throws an exception as given below

Error code 923, SQL state 42000: ORA-00923: FROM keyword not found where expected
Line 1, column 1
Execution finished after 0 s, 1 error(s) occurred.

Looks like its considering the rest of the statement after '#' as comment.

Let me know if you need any more details to reproduce the issue.


By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo