Empty Table => looping Page?
I have a view without Data in it:
i use it in comment region a classic report has the same problemo..
This are my settings
this is the result: Waiting circle:
Get the Session and Query:
SELECT SQL_ID
FROM V$SESSION
WHERE STATUS = 'ACTIVE' and username = 'APEX_PUBLIC_USER';
The QUERY:
SELECT
*
FROM
v$sql
WHERE
sql_id IN ( 'c3wy7rbkh4ngr' )
Result:
SELECT /*+qb_name(apex$1300_13100)*/
*
FROM
(
SELECT
a.*
, ROW_NUMBER()
OVER(
ORDER BY
NULL
) apx$rownum
FROM
(
SELECT
i.*
FROM
(
SELECT
"AKTION_OID"
, "START_TIME"
, "KOMMENTAR"
, "H$APP_USER"
FROM
(
SELECT /*+ qb_name(apex$inner) */
d."AKTION_OID"
, d."START_TIME"
, d."KOMMENTAR"
, d."H$APP_USER"
FROM
(
SELECT
x.*
FROM
"AKT_STAMM_KOMMENTARE" x
WHERE
( aktion_oid = :p13100_aktion_oid) )
) d
) i
) i
WHERE
1 = 1
ORDER BY
"AKTION_OID" ASC NULLS LAST
) a
)
WHERE
apx$rownum <= :p$_max_rows
If i do this query in sqldeveloper all is fine..
But in Apex it loops or whatever..
DB Monitor:
What is going on here?
Page loads forever.. if i disable the region.. all is good.. mano Oracle?
oky.. i take further investigations
It is possible to add hints, but i which will help here?