Date:         Mon, 9 Mar 2009 01:57:39 -0400
Reply-To:     Harry <dj_epw@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Harry <dj_epw@YAHOO.COM>
Subject:      ERROR: ORACLE prepare error: ORA-24333

I get an error when I run the below SAS code


data _null_;
 proc sql ;
    connect to oracle (user= &userid
password= "&orapass" path= &ora_path ) ;
    select * from connection to oracle
    (EXEC(EXEC DI_PROC_IMP_RESULT_UPDATE) BY
ORACLE);
    disconnect from oracle ;
 quit;
run;


ERROR: ORACLE prepare error: ORA-24333: zero iteration count. SQL
statement: EXEC(EXEC DI_PROC_IMP_RESULT_UPDATE) BY ORACLE.