LoadXML Incorrect XML Error

Discontinued products Uncategorized discussions
#1

loadXML error…Do you know what happened? There is no javascript error. The XML tags are returned one-by-one on-demand via a Oracle PL/SQL process. They are not stored in filesystem.



Javascript call:





On-demand process (Oracle PL/SQL) to return XML:

DECLARE

v_count number := 0;

BEGIN

OWA_UTIL.mime_header (‘text/xml’, FALSE);

HTP.p (‘Cache-Control: no-cache’);

HTP.p (‘Pragma: no-cache’);

OWA_UTIL.http_header_close;

HTP.prn ( ‘’ );



FOR c IN ( select a.mcm_pers_pk,

‘1’ dah_client,

ltrim(rtrim(a.pers_last_name)) pers_last_name,

ltrim(rtrim(a.pers_first_name)) pers_first_name,

ltrim(rtrim(a.pers_mi)) pers_mi,

a.dob,

a.pers_aka,

decode(a.ssn,null,null,substr(a.ssn,1,3) || ‘-’ || substr(a.ssn,4,2) || ‘-’ || substr(a.ssn,6)) ssn,

b.race_desc,

c.lang_desc,

d.sex_desc,

e.sexual_orientation

from mcm_pers_rev a, mcm_race b, mcm_lang c, mcm_sex d, code_sexual_orientation e

where a.ethnicity = b.race_code

and a.primary_lang = c.lang_code

and a.sex = d.sex_code

and a.sexual_orientation = e.sexual_orientation_code (+)

and a.pers_last_name like upper( v(‘F118_LAST_NAME_SEARCH’) ) || ‘%’

and a.pers_first_name like upper( v(‘F118_FIRST_NAME_SEARCH’) ) || ‘%’

and nvl( a.ssn,‘0’ ) like replace( v(‘F118_SSN_SEARCH’),’-’,NULL) || ‘%’

and nvl( a.dob,sysdate ) like to_date( v(‘F118_DOB_SEARCH’),‘MM/DD/RRRR’ ) || ‘%’

order by a.pers_last_name, a.pers_first_name )

LOOP

v_count := v_count + 1;



HTP.prn ( ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.mcm_pers_pk) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.dah_client) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.pers_last_name) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.pers_first_name) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.pers_mi) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.pers_aka) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.ssn) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.dob) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.sex_desc) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.lang_desc) || ‘’ );

HTP.prn ( ‘’ || htf.escape_sc(c.race_desc) || ‘’ );

HTP.prn ( ‘’ );

END LOOP;



HTP.prn ( ‘’ );

END;



#2

Is gReturn in above code an XML string? In such case it need to be loaded in grid with
mygrid.parse(gReturn,“xml”’);

load command - load data from external url
parse - loads data from local string|object

#3


Hi,



Yes, you are right.  I changed it to mygrid.parse(gReturn,“xml”) and it worked - gReturn is a local variable that stores the XML object returned by the on-demand process.



Btw, now I know I can integrate this product with Oracle Apex.  I only concern about the performance with the big datasets.  Do you have something called “SmartRending”?  Does it support pagination?  Do I have to buy the commercial license?



Thanks.



Andy

#4


Also, how can I turn on pagination - toolbar, bricks, etc.?  I think I downloaded the open-source version of DHTMLX grid.  Do I have to buy the latest commercial version?  What are the additional lines of code that I have to add to the javascript?



Thanks.



Andy

#5

Do you have something called “SmartRending”? Does it support pagination? Do I have to buy the commercial license?
There are two modes which can be used to work with big datasets
smart-rendering - exist in both pro and standard versions
paging - exists in pro version only

You can check the samples of usage at
sales@dhtmlx.com with such request )