Skip to Main Content

APEX

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!

An SQL Stmt

656541Oct 26 2008 — edited Oct 29 2008
I have a weird thing going here.

I have a query that runs in SQL Developer in 2.5 seconds on average.

The same query when i create a page in APEX (SQL Report or Interactive report) and i try to run it takes forever ... it doesnt even execute i left it for 10 mins and nothing.

I tried to delete and recreate the app, the page several times ...

Why would a query that runs in SQL Developer in 2.5 seconds, hangs with APEX?

Regards ....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Oct 26 2008
11 comments
522 views