Just to illustrate my problem again, this time with a proc ds2, which is what I want to use. The rollback in this program has no effect. The insert from the ins-statement stays. LIBNAME PD ORACLE READBUFF=100000 SQL_FUNCTIONS=ALL UPDATEBUFF=10000 INSERTBUFF=100000 OR_BINARY_DOUBLE=NO PATH=XXXX SCHEMA=XXX_XXX AUTHDOMAIN="Oracle.XXXX.XXX_XXX" ;
proc ds2 ;
data _null_;
method init();
declare package sqlstmt beg('begin');
declare package sqlstmt ins(%tslit(insert into pd.pd_jobs values (10,'test1',0)));
declare package sqlstmt rol('rollback');
beg.execute();
ins.execute();
rol.execute();
end;
enddata;
run;
... View more
