Hi all,
I'm working with an 11.2.0.2 Oracle database version.
I'm executing an script using Oracle Developer from my pc. I've to use Developer because the scritp have lines with more than 2500 characters.
The execution starts properly but, always fails with these error messages:
212 rows deleted
1 rows deleted
1 rows inserted
Error que empieza en la línea 6 del comando:
declare
stmt_hierarchyrow constant varchar2(255) := 'INSERT INTO HIERARCHY_ROWS (HIERARCHY_NAME, LOCATION_ID, LOCATION_NODE, NODE_VERSION) VALUES (:bind_var_1, :bind_var_2, :bind_var_3, :bind_var_4)';
begin
execute immediate stmt_hierarchyrow using 'DefaultHierarchy','CITY_JKT_ID','<Location xmlns="http://www.opentravel.org/OTA/2003/05" Id="CITY_JKT_ID" IndexNumber="5" Searchable="true" Version="22228" LocationType="city" HideName="false" TZ="" OnSale="true"><ChildLocations><LocationReference Id="AIR_CGK_ID" Index="2" /></ChildLocations><DateRanges></DateRanges><ParentLocations><LocationReference Id="COUNTRY_ID" Index="1" /></ParentLocations><AssociatedLocations></AssociatedLocations><Names><Name AlternativeSpelling="FALSE" Language="en" Value="Jakarta" AjaxString="Jakarta, Indonesia JKT" /></Names><Capabilities><Capability Type="car" Value="" /><Capability Type="flightCar" Value="" /></Capabilities><Codes><Code Context="HertzCityCodes" Value="RALE02" /><Code Context="ISOCountryCode" Value="ID" /><Code Context="RSV" Value="36139588" /><Code Context="HertzCityCodes" Value="MKCE16" /><Code Context="ViatorCityCodes" Value="JKT" /><Code Context="ServingAirport" Value="CGK" /><Code Context="ViatorCityCodes" Value="HLP" /><Code Context="HertzCityCodes" Value="INDC35" /><Code Context="HertzCityCodes" Value="INDC10" /><Code Context="HertzCityCodes" Value="INDC42" /><Code Context="GTA" Value="JKT" /><Code Context="IATA" Value="JKT" /><Code Context="HertzCityCodes" Value="INDC22" /><Code Context="HertzCityCodes" Value="INDC14" /><Code Context="HertzCityCodes" Value="INDC23" /><Code Context="Kuoni" Value="1818" /><Code Context="HertzCityCodes" Value="PSPS30" /><Code Context="IATA" Value="CGK" /><Code Context="ViatorCityCodes" Value="CGK" /><Code Context="ServingAirport" Value="HLP" /><Code Context="HB" Value="JAV|1" /></Codes><DescriptiveTags></DescriptiveTags><Position Latitude="-6.211544" Longitude="106.84517" Radius="2" Zoom="9"><Poly></Poly></Position></Location>','1';
(...)
execute immediate stmt_hierarchyrow using 'DefaultHierarchy','CITY_NGO_JP','<Location xmlns="http://www.opentravel.org/OTA/2003/05" Id="CITY_NGO_JP" IndexNumber="5" Searchable="true" Version="22208" LocationType="city" HideName="false" TZ="" OnSale="true"><ChildLocations><LocationReference Id="AIR_NGO_JP" Index="2" /></ChildLocations><DateRanges></DateRanges><ParentLocations><LocationReference Id="COUNTRY_JP" Index="1" /></ParentLocations><AssociatedLocations></AssociatedLocations><Names><Name AlternativeSpelling="FALSE" Language="en" Value="Nagoya" AjaxString="Nagoya, Japan NGO" /></Names><Capabilities></Capabilities><Codes><Code Context="ViatorCityCodes" Value="NGO" /><Code Context="IATA" Value="NGO" /><Code Context="RSV" Value="36139614" /><Code Context="GTA" Value="NGO" /><Code Context="Kuoni" Value="1829" /><Code Context="ISOCountryCode" Value="JP" /></Codes><DescriptiveTags></DescriptiveTags><Position Latitude="35.181446" Longitude="136.9064" Radius="2" Zoom="9"><Poly></Poly></Position></Location>','1';
end;
Inform error:
I/O Error: Software caused connection abort: socket write error
Have someone an idea to solve it?
Best regards,
dbajug