| Breaking connection to server while executing SQL query [message #118337] |
Wed, 04 May 2005 08:36  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
