Home » SQL & PL/SQL » SQL & PL/SQL » ORA-30926: unable to get a stable set of rows in the source tables (Oracle 10g)
ORA-30926: unable to get a stable set of rows in the source tables [message #352538] |
Wed, 08 October 2008 05:29  |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
I get the following error when i run the below query inside the package
MERGE INTO mytable P
USING IB_EXT_OCUVUELOS_V E
ON (P.FLTDEP_DT = E.FLTDEP_DT
AND P.FLTNO = E.FLTNO
AND P.CARRIER_CODE = E.CARRIER_CODE
AND P.ORIGIN = E.ORIGIN
AND P.DESTINATION = E.DESTINATION)
WHEN MATCHED THEN
UPDATE
SET type_of_aircraft = E.type_of_aircraft,
tail_number = E.tail_number,
ptow = E.ptow,
densification = E.densification,
dep_dt = E.dep_dt,
temperature = E.temperature,
origin_area = E.origin_area,
destination_area = E.destination_area,
payload = E.payload,
no_of_passengers = E.no_of_passengers,
baggage_weight = E.baggage_weight,
no_of_pallets = E.no_of_pallets,
no_of_containers = E.no_of_containers,
outlier = null
WHEN NOT MATCHED THEN
INSERT (CARRIER_CODE, FLTNO, SUFFIX, TYPE_OF_AIRCRAFT, TAIL_NUMBER, PTOW, DENSIFICATION, FLTDEP_DT, DEP_DT, TEMPERATURE
,ORIGIN_AREA, ORIGIN, DESTINATION_AREA, DESTINATION, PAYLOAD, NO_OF_PASSENGERS, BAGGAGE_WEIGHT, NO_OF_PALLETS, NO_OF_CONTAINERS)
VALUES (
E.CARRIER_CODE, E.FLTNO, E.SUFFIX, E.TYPE_OF_AIRCRAFT, E.TAIL_NUMBER, E.PTOW, E.DENSIFICATION, E.FLTDEP_DT, E.DEP_DT, E.TEMPERATURE
,E.ORIGIN_AREA, E.ORIGIN, E.DESTINATION_AREA, E.DESTINATION, E.PAYLOAD, E.NO_OF_PASSENGERS, E.BAGGAGE_WEIGHT, E.NO_OF_PALLETS, E.NO_OF_CONTAINERS);
ORA-30926: unable to get a stable set of rows in the source tables
Can any one pls guide over this
Thanks in Advance
[Edit MC: table name changed at OP's request]
[Updated on: Thu, 23 October 2008 00:39] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: ORA-30926: unable to get a stable set of rows in the source tables [message #352576 is a reply to message #352567] |
Wed, 08 October 2008 07:23  |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
hi guys,
I was trying with the condition given in the query all the condition satisfies i didnt get a way to solve this problem
but i tried the below one where the payload updation has been commented and the merge statement runs sucessfully
MERGE INTO mytable P
USING IB_EXT_OCUVUELOS_V E
ON (P.FLTDEP_DT = E.FLTDEP_DT
AND P.FLTNO = E.FLTNO
AND P.CARRIER_CODE = E.CARRIER_CODE
AND P.ORIGIN = E.ORIGIN
AND P.DESTINATION = E.DESTINATION)
WHEN MATCHED THEN
UPDATE
SET type_of_aircraft = E.type_of_aircraft,
tail_number = E.tail_number,
ptow = E.ptow,
densification = E.densification,
dep_dt = E.dep_dt,
temperature = E.temperature,
origin_area = E.origin_area,
destination_area = E.destination_area,
[B]--payload = E.payload,[/B]
no_of_passengers = E.no_of_passengers,
baggage_weight = E.baggage_weight,
no_of_pallets = E.no_of_pallets,
no_of_containers = E.no_of_containers,
outlier = null
WHEN NOT MATCHED THEN
INSERT (CARRIER_CODE, FLTNO, SUFFIX, TYPE_OF_AIRCRAFT, TAIL_NUMBER, PTOW, DENSIFICATION, FLTDEP_DT, DEP_DT, TEMPERATURE
,ORIGIN_AREA, ORIGIN, DESTINATION_AREA, DESTINATION, PAYLOAD, NO_OF_PASSENGERS, BAGGAGE_WEIGHT, NO_OF_PALLETS, NO_OF_CONTAINERS)
VALUES (
E.CARRIER_CODE, E.FLTNO, E.SUFFIX, E.TYPE_OF_AIRCRAFT, E.TAIL_NUMBER, E.PTOW, E.DENSIFICATION, E.FLTDEP_DT, E.DEP_DT, E.TEMPERATURE
,E.ORIGIN_AREA, E.ORIGIN, E.DESTINATION_AREA, E.DESTINATION, E.PAYLOAD, E.NO_OF_PASSENGERS, E.BAGGAGE_WEIGHT, E.NO_OF_PALLETS, E.NO_OF_CONTAINERS);
[Edit MC: table name changed at OP's request]
[Updated on: Thu, 23 October 2008 00:40] by Moderator Report message to a moderator
|
|
|
Goto Forum:
Current Time: Thu Feb 13 03:15:44 CST 2025
|