I can't find much infromation on this but I think it's not going to be possible as ODP.NET doesn't seem to let you execute multiple statements as a single command.
If I had the following query
CREATE PRIVATE TEMPORARY TABLE ora$ptt_Stops
(
MachineStopID NUMBER,
LineID NUMBER
)
ON COMMIT DROP DEFINITION;
INSERT INTO ora$ptt_Stops
SELECT MachineStop.MachineStopID,
Line.LineID
FROM Line
INNER JOIN LkLLS ON Line.LineID = LkLLS.LineID
INNER JOIN MachineStage ON LkLLS.LineSection = MachineStage.LineSectionID
INNER JOIN MachineStop ON MachineStage.MachineStageID = MachineStop.MachineStopID;
SELECT MachineStopID,
LineID
FROM ora$ptt_Stops
Is it possible to execute this as a single command in ODP.NET?
Attempts at the moment give this error.
"ORA-00922: missing or invalid option"