I'm stuck on this one.... Here is the proc in TOAD (It runs correctly): DECLARE P_A CHAR(2); P_B CHAR(3); P_C VARCHAR2(32767); P_D VARCHAR2(32767); P_E VARCHAR2(32767); P_F NUMBER; P_G NUMBER; P_H CHAR(2); P_I CHAR(4); P_J VARCHAR2(32767); P_K NUMBER; P_L VARCHAR2(20); P_M VARCHAR2(40); P_NNUMBER; BEGIN P_A := '99'; P_B := 'AA'; P_C := 'H'; P_D := 'Y'; P_E := '99999999999999999'; P_F := NULL; P_G := NULL; P_H := NULL; P_I := NULL; P_J := NULL; P_K := NULL; P_L := NULL; P_M := NULL; P_N := NULL; PKG_PROC ( P_A, P_B, P_C, P_D, P_E, P_F, P_G, P_H, P_I, P_J, P_K, P_L, P_M, P_N); dbms_output.put_line(P_M); dbms_output.put_line(P_N); END; When I try the pass-through using this SAS code: /**/ proc sql; connect to oracle (user= 'UserID' password= 'Pass' path= server); execute (call PKG_PROC ('99','AA','H','Y','99999999999999999',null,null,null,null,null,null,null,null,null)) by oracle; disconnect from oracle; quit; I get this error: ORACLE execute error: ORA-06550: line 1, column 79:PLS-00363: expression ' NULL' cannot be used as an assignment targetORA-06550 If try to omit the null parameters I get another error for not having enough parameters....I don't know how to pass the nulls. Also in the SAS documentation it says that you have to call a proc with another proc that calls that one and writes results in a temp table in oracle which you can then view from SAS...I wonder if that's another issue.
... View more
