Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using temporary tables in a query

Mike NJan 18 2021 — edited Jan 18 2021

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?

Comments
Post Details
Added on Jan 18 2021
17 comments
13,653 views