This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 187729

Summary:	Use of # in SQL command Editor throws an exception
Product:	serverplugins	Reporter:	sandy1264
Component:	OC4J	Assignee:	Michal Mocnak <mmocnak>
Status:	NEW ---
Severity:	normal	Keywords:	PLATFORM
Priority:	P1
Version:	6.x
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Exception Reporter:

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.