Home » Developer & Programmer » JDeveloper, Java & XML » Breaking connection to server while executing SQL query
Breaking connection to server while executing SQL query [message #118337] Wed, 04 May 2005 08:36 Go to next message
Nainar
Messages: 35
Registered: January 2005
Member
Hi,
I'm facing one problem. Whenever I execute this query in my oracle client m/c, it jus broken the connection to server.
This query is fetching value from XML document. I jus pasted the Query and results.

SQL> connect csar/csaroffshore@d106_offshore;
Connected.
SQL> SELECT EXTRACT(VALUE(t),'/Mapping/strSourceSystem/text()').GETSTRINGVAL(),
2 EXTRACT(VALUE(t),'/Mapping/strTraderID/text()').GETSTRINGVAL(),
3 EXTRACT(VALUE(t),'/Mapping/strSelectedAssignment/text()').GETSTRINGVAL(),
4 EXTRACT(VALUE(t),'/Mapping/strSelectedOrganization/text()').GETSTRINGVAL()
5 FROM TABLE (XMLSEQUENCE(EXTRACT(XMLTYPE('<Main><Mapping><strSourceSystem>FIM</strSourceSystem>
<strTraderID>Moynihan,Brendan</strTraderID><strAssociates>Jamie</strAssociates><strSelectedAssignmen
t>AddtoHierarchy</strSelectedAssignment><strSelectedOrganization>11</strSelectedOrganization></Mappi
ng><Mapping><strSourceSystem>FIM</strSourceSystem><strTraderID>Moynihan,Brendan</strTraderID><strAss
ociates>Jamie</strAssociates><strSelectedAssignment>AddtoHierarchy</strSelectedAssignment><strSelect
edOrganization>11</strSelectedOrganization></Mapping></Main>'),'/Main/Mapping'))) t
6 /
SELECT EXTRACT(VALUE(t),'/Mapping/strSourceSystem/text()').GETSTRINGVAL(),
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>


If any one faced the same problem, Kindly giv me some suggestion.

Thanks in advance.

icon5.gif  Re: Breaking connection to server while executing SQL query [message #120354 is a reply to message #118337] Thu, 19 May 2005 04:32 Go to previous message
ramasarma
Messages: 1
Registered: May 2005
Junior Member
hi,
i am facing the same exact problem since 2 days now.
did you get any answer for this problem?

If you have the answer for this problem.. Please let me know

thanks
Sarma
Previous Topic: How to create an XSL-FO template for XML Publisher 5.0
Next Topic: Java Stored Procedure only work in First Connection.
Goto Forum:
  


Current Time: Tue Feb 27 03:43:26 CST 2024