search

timithy3 / jqgrid-for-plsql

Automatically exported from code.google.com/p/jqgrid-for-plsql
0 stars 0 forks source link

ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing LPX-00601: Invalid token in: '*[count(../*[name(../*)=name(.)])=count(../*) and count(../*)null;1]' #5

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Start application
2. Click on link to page 2
3. Or Run page 3

What is the expected output? What do you see instead?
The grid
ORA-31011: XML parsing failed ORA-19202: Error occurred in XML processing 
LPX-00601: Invalid token in: '*[count(../*[name(../*)=name(.)])=count(../*) and 
count(../*)null;1]' 

What version of the product are you using? On what operating system?
Windows XP
Oracle XE
APEX 4.0 which has the following built into it:
<script 
src="/i/libraries/jquery-ui/1.8/ui/minified/jquery-ui-1.8.custom.min.js" 
type="text/javascript"></script>

Please provide any additional information below.
I put debug statements in JSON_UTIL_PKG and found that it gives the error while 
executing 
l_json := l_xml.transform (xmltype(get_xml_to_json_stylesheet));

Any help would be appreciated.

Original issue reported on code.google.com by bcarlis_...@yahoo.com on 17 Oct 2010 at 6:17

GoogleCodeExporter commented 8 years ago 
In the JSON_UTIL_PKG 
http://www.w3.org/TR/xslt says the Latest version is 
"http://www.w3.org/TR/xslt" 
so I changed 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 to 
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/TR/xslt">
just for the heck of it as I was researching it.. and shazam the l_json 
returned was readable after converting it to clob...

Still no grid but at least no errors at present. I am still tracing it.

Original comment by bcarlis_...@yahoo.com on 17 Oct 2010 at 8:44

GoogleCodeExporter commented 8 years ago 
Actually I read one of the posts on installation and found that these two 
packages were different between the supplied ones and my installed ones due to 
the prompting for arguments during the running of the install script.
As it is stated, run the install script using "set scan off;"
or as I did after the install I pasted the body into APEX SQL Workshop and 
compiled.
package body jqgrid_pkg
package body json_util_pkg

I got data immediately for page2 "Grid Number Two" but I still have no data for 
the "My Grid" and the "Testing jQGrid from PL/SQL !"

Original comment by bcarlis_...@yahoo.com on 17 Oct 2010 at 9:51

GoogleCodeExporter commented 8 years ago

Original comment by thehunge...@gmail.com on 22 May 2012 at 8:58