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!

CREATE PRIVATE TEMPORARY TABLE NOT SUPPORTED BY ODP.NET

User_2XBMEApr 22 2022

I'm trying to execute a a simple command:
CREATE PRIVATE TEMPORARY TABLE "ORA$PTT_TESTP" ("TEST" CHAR(4)) ON COMMIT DROP DEFINITION;
Using:
using (OracleCommand command = new OracleCommand(s, con)) {
command.ExecuteNonQuery();
}
But give me a validation error using Oracle.ManagedDataAccess 21.5.0
This is valid when I run in sqldeveloper - is this missing from Oracle.ManagedDataAccess??

Comments
Post Details
Added on Apr 22 2022
1 comment
172 views