SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00936: missing expression - using SubQueries using OLEDB Driver

388039Feb 18 2003 — edited Feb 19 2003

Oracle has added support for sub-queries since Oracle 8.1, but I'm getting an error when I try to perform a simple select.
ORA-00936: missing expression
select ITEMS.ITEM_NAME
, (select count(*) from WORK_FLOW.ITEM_ID = ITEMS.ITEM_ID) as ItemsBeingUse
from ITEMS
I do not want to use any other SQL code to perform this action. I have to see how the count could be placed in the FROM clause

It does work from Oracle SQL Plus Worksheet. I just don't understand why it is not working through the Oracle OLE DB driver. Oracle ODBC is not an option as it crashes endlessly.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2003

Added on Feb 18 2003

6 comments

2,573 views