topic Re: How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loadi in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-do-I-set-the-Oracle-commit-level-in-Proc-SQL-Access-for/m-p/805948#M81720 <P>Not sure what you mean by Oracle commit level. Search Oracle forums for the required Oracle command you want to run - not really a SAS question. These will work in the SAS EXECUTE statement in SQL Passthru. If you mean setting the number of rows to be included in an Oracle COMMIT, then the SAS option DBCOMMIT can do that.</P> Mon, 04 Apr 2022 21:37:14 GMT SASKiwi 2022-04-04T21:37:14Z How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loading? https://communities.sas.com/t5/SAS-Procedures/How-do-I-set-the-Oracle-commit-level-in-Proc-SQL-Access-for/m-p/805943#M81719 <P>Running on RH Linux 3.10.0-1160.53.1.el7.x86_64 (LIN X64),&nbsp;</P><P>SAS 9.4&nbsp;(TS1M6)</P> Mon, 04 Apr 2022 21:24:18 GMT https://communities.sas.com/t5/SAS-Procedures/How-do-I-set-the-Oracle-commit-level-in-Proc-SQL-Access-for/m-p/805943#M81719 DougZ 2022-04-04T21:24:18Z Re: How do I set the Oracle commit level in Proc SQL/Access for Oracle (execute statement) for loadi https://communities.sas.com/t5/SAS-Procedures/How-do-I-set-the-Oracle-commit-level-in-Proc-SQL-Access-for/m-p/805948#M81720 <P>Not sure what you mean by Oracle commit level. Search Oracle forums for the required Oracle command you want to run - not really a SAS question. These will work in the SAS EXECUTE statement in SQL Passthru. If you mean setting the number of rows to be included in an Oracle COMMIT, then the SAS option DBCOMMIT can do that.</P> Mon, 04 Apr 2022 21:37:14 GMT https://communities.sas.com/t5/SAS-Procedures/How-do-I-set-the-Oracle-commit-level-in-Proc-SQL-Access-for/m-p/805948#M81720 SASKiwi 2022-04-04T21:37:14Z