SQL Developer

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!

Unable to query View

647990Jul 2 2008 — edited Jul 4 2008

I am attempting to query a view but it returns no rows in SQL Developer.

SELECT * FROM apps.pa_cc_gl_cost_xfer_audit_v

This is a standard view from Oracle Project Costing..the same view does fetch rows when run from TOAD.
I am using SQL Developer version 1.2.1.
Can someone suggest possible reasons and how to fix.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2008

Added on Jul 2 2008

#sql-developer

3 comments

3,779 views