Re: Processing results from a stored procedure

[gadiy@sun4.miti.com]

     >>>> Is there a way to process rows or return values returned 
     >>>> from a stored procedure in SQR?
     
     With SQR/ORACLE, you can execute a PL/SQL block (that invokes the stored 
     procedure) in a "begin-sql" section. You can pass variables both IN and 
     OUT. 
     
     The feature of returning multiple rows from an ORACLE stored procedure 
     does not exist in ORACLE yet. I understand its coming soon in the form of 
     a procedure that returns a cursor. We'll have to think of a mechanism in 
     SQR to support that when it comes.
     
     With SQR/Sybase (and I believe also with Ingres), you can use the SQR 
     EXECUTE command to process rows or return values returned from a stored 
     procedure.
     
     I hope this answers your question. If not, please give more details of 
     what you are trying to do.
     
     Gadi Yedwab
     MITI