| Author |
Message
|
| ganeshkj |
 Posted: Thu Jun 03, 2004 9:14 am Post subject: XMLType Data Insertion..Any limit in the length? |
 |
|
Novice
Joined: 02 Jun 2004
Posts: 13
Location: Bangalore
|
Hi all,
In Oracle 9.2.0.4, I am inserting value for a XMLType field. When i am inserting smaller message it is inserting perfectly. But if the XML message is little bigger, I am getting the following error message:
SQL State 'HY000'; Native Error Code '21700'; Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-21700: object does not exist or is marked for delete
Any pointers or suggestions ?
Thanx and regards
Ganesh |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Jun 03, 2004 10:55 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
How big is your message?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| JT |
| Posted: Thu Jun 03, 2004 11:26 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Can you post the SQL statement? |
|
| Back to top |
|
|
| ganeshkj |
| Posted: Fri Jun 04, 2004 1:24 am Post subject: |
|
|
Novice
Joined: 02 Jun 2004
Posts: 13
Location: Bangalore
|
Hi,
When i inserted the following XML message, it is inserted successfully.
<XYZMessage><Header><ProcSeqNbr>973674</ProcSeqNbr><TypeSeqNbr>1</TypeSeqNbr><MessageType>CPTFUEL</MessageType><Transaction>CPTFUEL</Transaction><Source>ACARS</Source><Timestamp>2003-11-07 23:07:51</Timestamp></Header><FlightLeg><CarrierCode>XYZ</CarrierCode><FlightNumber>21</FlightNumber><OperationalSuffix> </OperationalSuffix><LogDate>2001-11-07 00:00:00</LogDate><OriginStation>LHR</OriginStation><DestinationStation>IAD</DestinationStation></FlightLeg><MessageID>1068246470</MessageID><Registration>G-VHOT</Registration><UpliftFuel>925160</UpliftFuel><Units>L</Units><ExtraFuelReason>00</ExtraFuelReason><SpecificGravity>0.7920</SpecificGravity><CaptainID>00017914</CaptainID></XYZMessage>
Unsuccessful XML message
==================
<LoadsheetMessage xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:\loadsheet.xsd"><AdressAndHeading><Priority>QU</Priority><Addresses><Address>LGWFRVS</Address></Addresses><Originator>LGWFRVS</Originator><AirlineDesig>AB</AirlineDesig><Date>2003-09-06</Date><Time>17:26:00</Time><LDM>String</LDM><EDNO>1</EDNO><From>LHR</From><To>EWR</To><FlightIdentifier><AirlineDesig>AB</AirlineDesig><FlightNumber>117</FlightNumber><FlightSuffix>-</FlightSuffix><ScheduledDt>2003-09-06</ScheduledDt></FlightIdentifier><AircraftRegn>GVSEA</AircraftRegn><Version><Capacity>40</Capacity><Class>J</Class></Version><Version><Capacity>28</Capacity><Class>W</Class></Version><Version><Capacity>187</Capacity><Class>Y</Class></Version><Crew><NoOfCockpitCrew>3</NoOfCockpitCrew><NoOfCabinCrew>12</NoOfCabinCrew><NoOfMaleCabinCrew>5</NoOfMaleCabinCrew><NoOfFemaleCabinCrew>10</NoOfFemaleCabinCrew></Crew><DepartureDate>2003-09-06</DepartureDate><DepartureTime>17:26:00</DepartureTime></AdressAndHeading><LoadAndDistribution><CmptmntWeight>20482</CmptmntWeight><LoadInCmptmnts><CompartmentNo>1</CompartmentNo><CompartmentWeight>1230</CompartmentWeight></LoadInCmptmnts><LoadInCmptmnts><CompartmentNo>2</CompartmentNo><CompartmentWeight>12905</CompartmentWeight></LoadInCmptmnts><LoadInCmptmnts><CompartmentNo>3</CompartmentNo><CompartmentWeight>2946</CompartmentWeight></LoadInCmptmnts><LoadInCmptmnts><CompartmentNo>4</CompartmentNo><CompartmentWeight>3192</CompartmentWeight></LoadInCmptmnts><LoadInCmptmnts><CompartmentNo>5</CompartmentNo><CompartmentWeight>210</CompartmentWeight></LoadInCmptmnts><PAXWeight>15700</PAXWeight><Males>110</Males><FemalesOrAdults>80</FemalesOrAdults><Chd>12</Chd><Inf>0</Inf><TotalPAXNum>202</TotalPAXNum><CabinBag>0</CabinBag><PAX><PAXPerClass>10</PAXPerClass><PAXClass>J</PAXClass></PAX><PAX><PAXPerClass>5</PAXPerClass><PAXClass>W</PAXClass></PAX><PAX><PAXPerClass>187</PAXPerClass><PAXClass>Y</PAXClass></PAX><SOC><SeatsOccupiedByCargo>0</SeatsOccupiedByCargo><SeatsOccupiedByBaggage>0</SeatsOccupiedByBaggage><SeatsOccupiedByMail>0</SeatsOccupiedByMail></SOC><BLKD><BlockedSeatsPerClass>0</BlockedSeatsPerClass><BLKDClass>J</BLKDClass></BLKD><TotTrafficLd>36183</TotTrafficLd></LoadAndDistribution><GrossWtCalc><DryOprtngWt>134061</DryOprtngWt><ZeroFuelWt>170244</ZeroFuelWt><MaxZeroFuelWt>174000</MaxZeroFuelWt><TakeOffFuel>6330</TakeOffFuel><TakeOffWt>233544</TakeOffWt><MaxTakeOffWt>257000</MaxTakeOffWt><TripFuel>51100</TripFuel><LandingWt>182444</LandingWt><MaxLandingWt>186000</MaxLandingWt><UnderLoadBeforeLMC>3556</UnderLoadBeforeLMC></GrossWtCalc><BalanceAndSheetingConditions><BalAndSheetingCondtns>DOI 24.68 MACTOW 27.1 MACZFW 27.6 STAB TRIM -5.1 NOSE UP VALID FOR FLAPS ANY CONF CABIN AREA TRIM - OA 10 OB 70 OC 122</BalAndSheetingCondtns><Destn>EWR</Destn><Spec>String</Spec><CLCpt>String</CLCpt><OnOffLoad>-</OnOffLoad><LMCWeight>0</LMCWeight><LMCTotal>String</LMCTotal><LMCTotalWt>0</LMCTotalWt></BalanceAndSheetingConditions><CaptainsInfoNotes>-EWR.110/80/12/0.T20483.1/1230.2/12905.3/2946.4/3192.5/210 .PAX/10/5/187.PAD/0/0/0.BBY/5/0</CaptainsInfoNotes><LoadMessagesBeforeLMC>String</LoadMessagesBeforeLMC><Signatures><Checked>ALEX BARTATA</Checked><Approved>String</Approved></Signatures><SupplimentaryInformation><To>EWR</To><BaggageWt>4368</BaggageWt><MailWt>0</MailWt><CargoWt>15485</CargoWt><VirginMailWt>0</VirginMailWt><SI>String</SI></SupplimentaryInformation></LoadsheetMessage>
Hope this info helps.....
Thnx and regards
Ganesh |
|
| Back to top |
|
|
| ganeshkj |
| Posted: Tue Jun 08, 2004 1:06 am Post subject: |
|
|
Novice
Joined: 02 Jun 2004
Posts: 13
Location: Bangalore
|
Guys,
Figured out it is not MQSI or Driver issue.....it's a oracle problem...I tried inserting from the Sql prompt the samle XML data. It is giving the same error message..
Will post the exact reason once the solution is arrived.
Rgds
Ganesh |
|
| Back to top |
|
|
| ganeshkj |
| Posted: Tue Jun 08, 2004 3:18 am Post subject: Soln:: |
|
|
Novice
Joined: 02 Jun 2004
Posts: 13
Location: Bangalore
|
Guys,
problem while insertion was because of the XSD location mentioned...Seems Oracle 9.2.0.3 version automatically checks for this XSD...
now everything is working fine....Sorry for this mistake..
Thnx and regards
Ganesh |
|
| Back to top |
|
|
|
|
