Columns added to Oracle table and missing in SAS

[foxrol]

Hi everyone,

I've one issue.

Since today i was having a libname to connect to Oracle and see all columns of one Oracle table.

Now, an DBA added three columns to an Oracle table and I have to feed them.

I'm facing a big issue because i don't see those three new columns when using the same libanme.

Could you tell me what to do? Do i have to update metadata?

Thanks

[SASKiwi]

If you are registering the Oracle tables in SAS metadata then yes. Personally I prefer to avoid such issues by using the AssignMode=2 extended attribute in the metadata library definition.