Skip to Main Content
Forums

Oracle Database Discussions

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!

ORA-00904 invalid identifier when dropping generated column

User_77G7LMar 9 2022

Hello,
I have a table that was created as
CREATE TABLE xxx (
"SHAPE" "SDO_GEOMETRY",
"X_VALUE" NUMBER GENERATED ALWAYS AS ((("MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE"("SHAPE",0.005))."SDO_POINT")."X") VIRTUAL ,
"Y_VALUE" NUMBER GENERATED ALWAYS AS ((("MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE"("SHAPE",0.005))."SDO_POINT")."Y") VIRTUAL)
Both X_VALUE and Y_VALUE columns are created from the SHAPE (SDO_GEOMETRY) column, but when I want to drop them with:
ALTER TABLE xxx DROP (X_VALUE, Y_VALUE)
I get the error "ORA-00904: "MDSYS"."SDO_GEOM"."SDO_POINTONSURFACE": invalid identifier". Am I doing something wrong?
This post has been answered by Jonathan Lewis on Mar 9 2022
Jump to Answer

Comments

Alex Keh-Oracle

Looks the same as Issue #109.
There will be a new AddOracleTypesDeserialization method to resolve this issue in the next ODP.NET version.

User_TKA7X
Answer

Alex,
Thanks so much for the super fast feedback. Your link provided me with the workaournd I needed.
By putting this in my project file, it works now.
<EnableUnsafeBinaryFormatterSerialization>true</EnableUnsafeBinaryFormatterSerialization>
Regards,
Jason

Marked as Answer by User_TKA7X · Nov 12 2020
1 - 2

Post Details

Added on Mar 9 2022
#general-database-discussions
2 comments
737 views