Using Private Temporary Table with ODP.NET

136 Views Asked by At

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"
0

There are 0 best solutions below