| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: xml / xsql possible setup problem
Hi,
Yes we tried ofcourse to do select from the output table manually and this
works fine.
Forgot to do a trace
And I just did with remarkable result that
I See a dump in the trace file in the case of rownum < 62 which gives me
more indication
that we pass some kind of limit.Any idea what this means?
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmxsqLoadNS], [], [], [], [],
[], [], []
Current SQL statement for this session:
insert into testxml (msgtext,version) values (:1,:2)
----- PL/SQL Call Stack -----
object line object
handle number name
c000000014ca4080 0 SYS.XMLTYPE
c000000014cc8580 17 VRIJ_UIT.TESTXMLTRIG
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- --------------------
----------------------------
ksedmp()+184 ? ksedst() 8000000100112630 ?
000000000 ?
C00000001188DC00 ?
000000000 ?
ksfdmp()+32 ? ksedmp() C00000001183BB28 ?
-----Oorspronkelijk bericht-----
Van: M.Godlewski [mailto:mcgodlewski_at_yahoo.com]
Verzonden: Monday, August 30, 2004 17:23
Aan: oracle-l_at_freelists.org
Onderwerp: Re: xml / xsql possible setup problem
Jeroen,
Have you run a trace on your session to see what is happening in the rownum < 61 query that is successful and what is different in the rownum < 62?
Secondly,
Have you tried to connecting directly to sqlplus to run the procedure and
direct the output to the screen?
Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl> wrote:
We encounter a strange problem in development of a new xml-based
application.
This might have something to do with setup so hopefully some of you can help
me a bit further on the road:
I post a XML message as a request to query some data . The server reponses
well if the amount of data to respond is not too much. If amount the data
exceeds a certain limit we get an error.
Flow we use:
for development we use an html form,
request goes to the apache webserver,
calls an xsql page,
page does an insert into a table with a clob column trigger on this table
calls a procedure to process the request -> output is prepared in a new
table in xml-format page does a query on the output table to prepare the
answer
Details: Oracle 9.2.0.4 HP-UX 11.11 XDK 9.2.0.6 ................The PL-sql to prepare the response:
dum clob;
CURSOR cResponseContractsList
IS
select XMLELEMENT("CBSMessage",
XMLATTRIBUTES('http://www.w3.org/2001/XMLSchema' as "xmlns:xsd" ,
'http://www.w3.org/2001/XMLSchema-instance' as "xmlns:xsi"
,'http://www.oracle.com/CBSResponse.xsd' as "xsi:noNamespaceSchemaLocation"
),
XMLELEMENT("Header",
XMLELEMENT("Version", '1'),
XMLELEMENT("Guid", '6BC096BB-0CE6-11D1-BAAE-00C04FC2E20D'),
XMLELEMENT("Error", 0)
XMLELEMENT("Response",
XMLELEMENT("Type", 'ResponseContractList'), XMLELEMENT("RequestID", 1),
XMLELEMENT("Error", 0), (select XMLAGG( XMLELEMENT("ResponseContractList",
(select XMLAGG(
XMLELEMENT("Object",
XMLELEMENT("ObjectID", OBJ_CD),
XMLELEMENT("ObjectName", OBJ_NM),
XMLELEMENT("ObjectRegion", rtrim(REG_NM)), (select XMLAGG(
XMLELEMENT("Contract", XMLELEMENT("ContractID", CNTR_CD),
XMLELEMENT("ContractName", nvl(OBJ_ECD,' ') || ' ' || OBJ_NM),
XMLELEMENT("ContractCode", nvl(CNTR_ECD,' ')), XMLELEMENT("StartDate",
to_char(min(RSTR_DTM_TOT),'yyyy-mm-dd')),
XMLELEMENT("EndDate", to_char(max(RSTR_DTM_TOT),'yyyy-mm-dd')),
XMLELEMENT("SupplierCode", OBJ_TARA_NR)
and ACC_ADR_OBJ = OBJ_CD and NAW_CD = ACC_ADR_NAW and REG_LAND = NAW_LAND and REG_STRK = NAW_STRK and REG_CD = NAW_REG
)))
from dual
))
) as "CBSResponse"
from dual;
BEGIN
OPEN cResponseContractsList;
FETCH cResponseContractsList into waarde; CLOSE cResponseContractsList;
delete dummy; insert into dummy (MSG) values (waarde); END
..........................
Posting the xml
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.oracle.com/CBSrequest2.xsd">
1
CBS
IRIS
6BC096BB-0CE6-11D1-BAAE-00C04FC2E20D
RequestContractList
26
6
Leads to a
OUTPUT WHEN THERE is too much data
-
-
oracle.xml.sql.OracleXMLSQLException: End tag does not match start tag
'ObjectRegion'.
................................
Hope you can help because we are getting desperate
Tnx,
Jeroen
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Aug 31 2004 - 02:13:15 CDT
 |
 |