Here is an excerpt from the log. I tried to insert two columns T1 = 111111111111111111 and T2 = 111111111111111112
From suspicious moments, I saw only this in the log:
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
options sastrace=',,,ds' sastraceloc=saslog ;
27 proc sql;
28 create table test_ma.test_tbl5
29 as select * from work.test;
0 1591617382 no_name 0 SQL (2)
ORACLE_1: Prepared: on connection 0 1 1591617382 no_name 0 SQL (2)
SELECT * FROM TEST_TBL5 2 1591617382 no_name 0 SQL (2)
3 1591617382 no_name 0 SQL (2)
4 1591617382 no_name 0 SQL (2)
Summary Statistics for ORACLE are: 5 1591617382 no_name 0 SQL (2)
Total SQL prepare seconds were: 0.003498 6 1591617382 no_name 0 SQL (2)
Total seconds used by the ORACLE ACCESS engine were 0.004462 7 1591617382 no_name 0 SQL (2)
8 1591617382 no_name 0 SQL (2)
9 1591617382 no_name 0 SQL (2)
ORACLE_2: Prepared: on connection 1 10 1591617382 no_name 0 SQL (2)
SELECT * FROM TEST_TBL5 11 1591617382 no_name 0 SQL (2)
12 1591617382 no_name 0 SQL (2)
13 1591617382 no_name 0 SQL (2)
Summary Statistics for ORACLE are: 14 1591617382 no_name 0 SQL (2)
Total SQL prepare seconds were: 0.001377 15 1591617382 no_name 0 SQL (2)
Total seconds used by the ORACLE ACCESS engine were 0.001772 16 1591617382 no_name 0 SQL (2)
17 1591617382 no_name 0 SQL (2)
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
18 1591617382 no_name 0 SQL (2)
ORACLE_3: Executed: on connection 2 19 1591617382 no_name 0 SQL (2)
CREATE TABLE TEST_TBL5(T1 NUMBER ,T2 NUMBER ) 20 1591617382 no_name 0 SQL (2)
21 1591617382 no_name 0 SQL (2)
22 1591617382 no_name 0 SQL (2)
ORACLE_4: Prepared: on connection 2 23 1591617382 no_name 0 SQL (2)
INSERT INTO TEST_TBL5 (T1,T2) VALUES (:T1,:T2) 24 1591617382 no_name 0 SQL (2)
25 1591617382 no_name 0 SQL (2)
26 1591617382 no_name 0 SQL (2)
2 The SAS System 14:53 Monday, June 8, 2020
ORACLE_5: Executed: on connection 2 27 1591617382 no_name 0 SQL (2)
INSERT statement ORACLE_4 28 1591617382 no_name 0 SQL (2)
29 1591617382 no_name 0 SQL (2)
ORACLE: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* 30 1591617382 no_name 0 SQL (2)
31 1591617382 no_name 0 SQL (2)
Summary Statistics for ORACLE are: 32 1591617382 no_name 0 SQL (2)
Total SQL execution seconds were: 0.047399 33 1591617382 no_name 0 SQL (2)
Total SQL prepare seconds were: 0.001399 34 1591617382 no_name 0 SQL (2)
Total SQL row insert seconds were: 0.016397 35 1591617382 no_name 0 SQL (2)
Total seconds used by the ORACLE ACCESS engine were 0.068465 36 1591617382 no_name 0 SQL (2)
37 1591617382 no_name 0 SQL (2)
NOTE: Table TEST_MA.TEST_TBL5 created, with 1 rows and 2 columns.
30 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.18 seconds
cpu time 0.03 seconds
... View more