• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2095
  • Last Modified:

Oracle APEX - Debugging

I have an apex application with 5 pages,

my load page runs the following query in 1 region

Select 
VENDOR,
CUSTITEMCODE,
ORD
from WAG
WHERE VENDOR = :P3_VENDOR

Open in new window


It runs this query in another region
select 
"ROWID",
"IN_ITEM",
"ORD",
"VENDOR"
from "#OWNER#"."RECINC"
WHERE VENDOR = :P3_VENDOR

Open in new window


I have this process as a PL/SQL block that runs when a button is clicked
BEGIN
INSERT INTO RECINC (
  IN_ITEM,
  ORD,
  "sDATE",
  VENDOR)
SELECT
  CUSTITEMCODE,
  ORD,
  SHIP_DATE,
  VENDOR
FROM WAG
WHERE VENDOR = :P3_VENDOR;
COMMIT;
END;

Open in new window


P3_VENDOR is a drop down list with 11 items

When i change value on the drop down list (p3_vendor) the first time i change, it goes fine, but when i try to change it again.

I get an error
Bad Request

The HTTP client sent a request that this server could not understand.

Open in new window


at the URL orcl.apexapp.com:8080/apex/wwv_flow.accept


I'm not sure whats causing them or how to debug the problem
0
futureDBA
Asked:
futureDBA
  • 4
1 Solution
 
sdstuberCommented:
in your url set debugging to YES

it might look something like this...

f?p=123:3:1234567890::YES
0
 
futureDBAAuthor Commented:
yes it is,
0
 
futureDBAAuthor Commented:
found the debug information.. nothing points. too why the error though
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
futureDBAAuthor Commented:
0.00750	0.00198	S H O W: application="133" page="3" workspace="" request="" session="0"	4	

0.00942	0.00165	Processing page view with session ID = 0	4	

0.01115	0.00578	...Page is public	4	

0.01685	0.00455	...Session ID read from cookie is: 144045160541801	4	

0.02140	0.00250	Language derived from: FLOW_PRIMARY_LANGUAGE, current browser language: en	4	

0.02390	0.00315	alter session set nls_language="AMERICAN"	4	

0.02711	0.00184	alter session set nls_territory="AMERICA"	4	

0.02889	0.00178	NLS: CSV charset=WE8MSWIN1252	4	

0.03066	0.00141	...NLS: Set Decimal separator="."	4	

0.03224	0.00200	...NLS: Set NLS Group separator=","	4	

0.03414	0.00199	...NLS: Set g_nls_date_format="DD-MON-RR"	4	

0.03611	0.00155	...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"	4	

0.03761	0.00170	...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"	4	

0.03931	0.00242	NLS: Language=en	4	

0.04173	0.00210	Application 133, Authentication: PLUGIN, Page Template: 1584307201203093	4	

0.04383	0.00247	...fetch session state from database	4	

0.04630	0.00206	fetch items	4	

0.04836	0.00187	...fetched 6 session state items	4	

0.05023	0.00280	Authentication check: No Authentication (NATIVE_DAD)	4	

0.05302	0.00240	... sentry+verification success	4	

0.05543	0.00137	...Session ID 144045160541801 can be used	4	

0.05680	0.00255	...Application session: 144045160541801, user=nobody	4	

0.05937	0.00209	...Setting session time_zone to -04:00	4	

0.06143	0.00349	Session: Fetch session header information	4	

0.06495	0.00213	Branch point: Before Header	4	

0.06787	0.00436	Fetch application meta data	4	

0.07143	0.00161	...metadata, fetch computations	4	

0.07302	0.00180	...metadata, fetch buttons	4	

0.07482	0.00195	...http header processing	4	

0.07677	0.00261	...set mime type: text/html	4	

0.07937	0.00160	...set additional http headers	4	

0.08097	0.00156	Computation point: Before Header	4	

0.08253	0.00120	Processes - point: BEFORE_HEADER	4	

0.08373	0.00129	...close http header	4	

0.08502	0.00281	...metadata, fetch item type settings	4	

0.08782	0.00494	...metadata, fetch items	4	

0.09279	0.00230	Show page template header	4	

0.09515	0.00466	Rendering form open tag and internal values	4	

0.09975	0.00134	Computation point: After Header	4	

0.10117	0.00380	Processes - point: AFTER_HEADER	4	

0.10489	0.00341	Region: Global	4	

0.10828	0.00405	Item: P0_DATE NATIVE_DATE_PICKER	4	

0.11233	0.00414	Item: P0_WH NATIVE_SELECT_LIST	4	

0.11647	0.00542	...Execute Statement: select /*+ cardinality(t 5) */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(1)) t order by insert_order	4	

0.12188	0.00246	Region: Load Controls	4	

0.12434	0.00137	Computation point: Before Box Body	4	

0.12571	0.00185	Processes - point: BEFORE_BOX_BODY	4	

0.12756	0.00430	Region: Loads Transfer	4	

0.13185	0.00270	Item: P3_VENDOR NATIVE_SELECT_LIST	4	

0.13458	0.00567	...Execute Statement: select /*+ cardinality(t 5) */ disp, val from table(wwv_flow_utilities.get_temp_lov_data(2)) t order by insert_order	4	

0.14022	0.00427	show report	4	

0.14450	0.00204	determine column headings	4	

0.14654	0.00192	parse query as: IMS	4	

0.14846	0.00320	...Execute Statement: Select VENDOR, CUSTITEMCODE, ORD from WAG WHERE VENDOR = :P3_VENDOR	4	

0.15166	0.00233	print column headings	4	

0.15409	0.02007	rows loop: 30 row(s)	4	

0.17415	0.00224	pagination	4	

0.17630	0.00437	Region: Receiving	4	

0.18067	0.00466	show report	4	

0.18533	0.00172	determine column headings	4	

0.18713	0.00330	activate sort	4	

0.19037	0.00216	parse query as: IMS	4	

0.19251	0.00317	...Execute Statement: select NULL "CHECK$01", NULL "APEX$ROWID", NULL "IN_ITEM", NULL "ORD", NULL "VENDOR" from dual union all select "CHECK$01", "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from (select NULL "CHECK$01", "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from ( select "ROWID" "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from "IMS"."RECINC" WHERE VENDOR = :P3_VENDOR) APEX$RPTSRC order by 1, 2)	4	

0.19568	0.00273	print column headings	4	

0.19841	0.99947	rows loop: 9999 row(s)	4	

1.19789	0.00154	pagination	4	

1.19940	0.00131	Computation point: After Box Body	4	

1.20071	0.00123	Processes - point: AFTER_BOX_BODY	4	

1.20208	0.00136	Computation point: Before Footer	4	

1.20329	0.00098	Processes - point: BEFORE_FOOTER	4	

1.20427	0.00134	Show page tempate footer	4	

1.20561	0.00163	Rendering form close tag and page checksum	4	

1.20724	0.00096	Computation point: After Footer	4	

1.20820	0.00132	Processes - point: AFTER_FOOTER	4	

1.20952	0.00097	v$sesstat.statistic# = 436: execute count=2	4	

1.21049	0.00234	Final commit	4	

1.21283	-	End Page Rendering	4	-

Open in new window

0
 
futureDBAAuthor Commented:
this lover here is kind of highlighted
0.19251	0.00317	...Execute Statement: select NULL "CHECK$01", NULL "APEX$ROWID", NULL "IN_ITEM", NULL "ORD", NULL "VENDOR" from dual union all select "CHECK$01", "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from (select NULL "CHECK$01", "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from ( select "ROWID" "APEX$ROWID", "IN_ITEM", "ORD", "VENDOR" from "IMS"."RECINC" WHERE VENDOR = :P3_VENDOR) APEX$RPTSRC order by 1, 2)	4	

0.19568	0.00273	print column headings	4	

0.19841	0.99947	rows loop: 9999 row(s)	4	

1.19789	0.00154	pagination

Open in new window

0
 
mradovan10Commented:
Your problem is probably located in :P3_VENDOR select list definition. First time it has some value, but after it was changet get some wrong or null value. What select list definition you have set?
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now