In the metadata definition, there is only the path stored, without an identification of the server on which it is located. The setup always assumes that you  connect to metadata start the SAS process from a definition on that metadata server use resources from that same metadata repository The SAS process assumes that its environment is consistent. By changing metadata servers mid-process, you undermine that. ... View more

Thank you very much to you all for your help. Sometimes you are really on the hose....   So easy...   Thanks to all   Best reagrds George ... View more

Thank you very much - works also correct:) ... View more

The SAS Access to Oracle Engine communicates with the Oracle client to communicate with your Oracle server.   In doing so the Access Engine must know of which data type a SAS variable should become for Oracle. Now standard SAS has only 2 variable types - numeric or character. So for SAS to pass on the correct type to Oracle (Date), SAS needs to know that the SAS variable of type Numeric represents a SAS Date or Datetime. The way SAS gets that is via the Format assigned to the numeric SAS variable - BUT: The SAS variable must remain numeric and not get converted to a string like done in your code.   IF you have already a permanend DATETIME. format assigned to variable "mdupdate" the you can just use it directly as below:   PROC SQL; INSERT INTO ORADB.TEST_TABLE (REPORT_CREATION) SELECT mdupdate from SB0520C.REPORTS; QUIT; IF "mdupdate" doesn't have a permanent format applied then something like below should work: PROC SQL; INSERT INTO ORADB.TEST_TABLE (REPORT_CREATION) SELECT mdupdate format=datetime21. from SB0520C.REPORTS; QUIT; What you also can do, is using data set option "dbtype" - but this should only be necessary in very special situations. http://support.sas.com/documentation/cdl/en/acreldb/69039/HTML/default/viewer.htm#p1dqaq7ub1cm1pn1ow3x9qkmkxe8.htm    BTW: I've made the experience that the SAS Access to Oracle engine doesn't recognize all SAS Date and Datetime formats (=eventually converting the SAS variable to an Oracle column of type numeric). If you want to stay on the save side then use DATE9. and DATETIME21.       ... View more