topic Re: dbconinit calling dabase procedure 2 times for for one execution in SAS Programming

dbconinit calling dabase procedure 2 times for for one execution

ajaybetham — Wed, 11 Apr 2018 21:20:50 GMT

I am using the below code to call a DB procedure from Sas. Sas is calling the procedure 2 times for one execution. Please help why it is calling the procedure 2 times.

%macro exsetup

%put &sysuserid;

proc sql;

connect to oracle(path=<<service>> user=<<username>> password=<<password>>);

libname l123 oracle user=<<username>> password=<<password>> path=<<service>>

dbconinit = "begin pkg.procedure_name(1234); end;";

quit;

%mend exsetup;

%exsetup;

Re: dbconinit calling dabase procedure 2 times for for one execution

SASKiwi — Thu, 12 Apr 2018 01:18:59 GMT

Embedding a LIBNAME statement inside PROC SQL makes no sense. Move it to open code. Also not sure why you need both a libname DB connection and also an SQL passthru DB connection. What does your complete code look like?

%macro exsetup
%put &sysuserid;

libname l123 oracle user=<<username>> password=<<password>> path=<<service>>
dbconinit = "begin pkg.procedure_name(1234); end;";

proc sql;
connect to oracle(path=<<service>> user=<<username>> password=<<password>>);
quit;
%mend exsetup;
%exsetup;