Home > database >  Turn a used to insert data into the oracle
Turn a used to insert data into the oracle

Time:10-27

Help you a question, I now want to send data from a SQL insert to the oracle, after writing a script
 INSERT OPENQUERY (oracle, 'select a, b, c, d, e, f, g the from QZJ. RECORD') 
SELECT DISTINCT RTRIM (a) a, RTRIM (b) b, RTRIM (c) c, RTRIM (d) d, RTRIM (e) e, RTRIM (f) f, RTRIM (g) g
The FROM QZJ. RECORD A
WHERE SCRQ='20201003'


The oracle in the script is the name of the link to the server, now I met a problem, the script executed when is the first time a success, the implementation of the second time to quote for the following error when

Message 7353, level 16, state 1, line 20
Link server "oracle" OLE DB access interface "OraOLEDB. Oracle offers inconsistent metadata, in the process of execution provides redundant, but did not find the column at compile time,

After about 10 minutes, this went up to re-execute the success, this is why...
  • Related