I need to use a MERGE statement, comparing / updating a large number of records. I tried to start it with `CREATE PRIVATE TEMPORARY TABLE ...; INSERT ...`, but gor an ORA-14451 "Upsupported feature" error. And no, I am not running the query as SYS
user.
Is it possible to use temporary tables in a query sent from .NET?
If not, what are my other options of providing data to MERGE
, if I really want to use parameters (array binding) instead of building a humongous UNION
statement?