Date:         Fri, 17 Apr 1998 03:27:18 GMT
Reply-To:     Renaud Langis <nakhob@MAT.ULAVAL.CA>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Renaud Langis <nakhob@MAT.ULAVAL.CA>
Organization: Universiti Laval
Subject:      Re: Pass-thru SQL
Content-Type: text/plain; charset=us-ascii

On Thu, 16 Apr 1998 20:45:47 -0400, awalker@jax-inter.net (Arthur) wrote:
 
>Anybody know if its possible to do cursor level stuff via the pass-thru SQL
>functionality of the PROC SQL statement. DECLARE CURSOR and FETCH.. stuff like
>that.
>
>If so could you post examples.
 
From what i tried, i think it is not possible. But you can create a procedure
in
ORACLE for example and call it from SAS with
 
Proc sql;
connect to oracle(user=.....);
execute(exec proc-name(param...)) by oracle;
disconnect from oracle;
quit;
 
The problem proc sql has with PL/SQL is that it doesn't like ";" inside an
execute() command.
 
R