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!

XMLFile parameter is not supported by Oracle APEX, please use setXMLFile() method instead

Selvaraj JeyachandranApr 24 2014 — edited May 13 2014

"XMLFile parameter is not supported by Oracle APEX, please use setXMLFile() method instead"

I was creating a test web app in apex.oracle.com to try few things. I created a 2D Pie Chart in Flash in a webpage and it seems to render alright. But before rendering, I am getting the above error message appearing on chart region for 1-2 seconds.

Can anynone tell me what the above error message means and  why i am getting this. I am not using any custom XML. Did not change any default settings of chart region.

I could see the above error message appearing clearly since the apex.oralce.com is so slow..and chart region takes a while to load. Otherwise i couldn't have noticed it. Happens in both IE8 and Google chrome.

Oralce Apex 4.2.5.00.006 (https://apex.oracle.com)

Google Chrome 34.0.01847.116

Internet Explorer 8.0.6001.19518

Can someone help please. I will try to get a test application setup dispalying this error message sometime sooner.

I was using HTML5 charts in apex 4.2.0.00.27 in my office workspace in my actual application. Most of my users are still using IE8. The HTML5 charts were all appearing fine in their IE8 browsers. One fine day, some settings must have changed by my network administrator or soemthing else might have happened. I have no clue. All my webapplication's HTML5 charts disappeared from IE8 users. IE9 users had no problem. I contacted our IT support staff about any security settings changes on that day or earlier. Absolutely no help to my frustration. I have to change my application's charts (only around 6 of them) to Flash charts to overcome this. That is the story behind why i am using Flash charts. If anyone experienced similar problem in IE8 HTML5 charts please shed some light to me..This problem could be totally unrelated to the "XMLFile paramter error message", but I am not sure.

This post has been answered by user10363847 on May 13 2014
Jump to Answer

Comments

John Thorton

580988 wrote:

Hi All,

I have a stored procedure which is running forever. The particular stored procedure reads a file and performs validation and inserts into some transaction table.

There are many stored procedures that are called within the main procedure. There might be locks or blocks or some query is taking long time to execute

How do i find out which query in which procedure is taking long time to execute? But sometimes the same procedures completes successfully within few seconds inserting

all the records (10000 recs).

Thanks

Gautam S

Consider to issue SQL below just prior to starting the rogue procedure.

ALTER SESSION SET SQL_TRACE=TRUE;  -- ensure the USER has necessary privilege to successfully run this SQL statement

process resultant trace file using TKPROF

ms

I just ran the main procedure now and it ran successfully within few seconds. I don't know why it was not running earlier 1 hour ago. Can someone throw some light on this?

Thanks

Gautam

John Thorton

580988 wrote:

I just ran the main procedure now and it ran successfully within few seconds. I don't know why it was not running earlier 1 hour ago. Can someone throw some light on this?

Thanks

Gautam

Something changed, but we don't know what you have.

Does any of the SQL in your mystery procedure use bind variables?

ms

No, none of the SQL use bind variables. My procedure calls the innermost procedure which is a PRAGMA AUTONOMOUS procedure.

FYI : The innermost procedure has a FOR UPDATE in a select clause. I have issued proper COMMIT/ROLLBACK also in that procedure. Does it have something to do with that? Also, the total record count i am processing is 10000.

Thanks

Gautam

ms

@John Thorton

However the records are processed successfully and inserted into relevant tables. Only the session keeps hanging in SQL Developer.

Let me know if you need anything else. If the session keeps hanging probably the application would also keep hanging in Production.

Can you someone kindly help on this.

Thanks

Gautam

ms

Hi all,

It's solved. The hanging was due to the excessive dbms_output messages being populated for each of the 10000 records.

Cookiemonster76

580988 wrote:

No, none of the SQL use bind variables.

Are you using dynamic SQL? Because unless you are, all your SQL will definitely be using bind variables. PL/SQL sorts that out automatically.

BEDE

The most simple thing is to use a log table and log there when the code gets to some place using a store procedure with pragma autonomous_transaction.

Or, you may see what shows in the sys.gv_$open_cursor and sys.gv_$sql for that session of yours, like below:

select sq.*

from sys.gv_$open_cursor oc

join sys.gv_$sql sq on oc.sql_id=sq.sql_id and oc.inst_id=sq.inst_id

where oc.sid=&sid and oc.inst_id=&inst_id

and sq.users_executing>0

;

If it's quite difficult to know which your session is, you may mark that session using the facilities of package dbms_application_info.

BEDE

If you suspect there may be some session blocking:

Select * from sys.gv_$session_blockers

;

And see what you get.

1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 10 2014
Added on Apr 24 2014
2 comments
1,841 views