RE: Processing results fro a stored procedure

["Schindler,John,JF" <SCHINDJF@rtlpo1.usaclv.msnet.bp.com>]

  Yes it is very easy to do, but some cautions are required.  You will need
  to use "Begin-Sql" and execute a PL/SQL block that in turn calls the 
procedure.

     Begin-Sql
       Begin
         <schema>.<procedure_name>(<parms>);;
       End;;
     End-Sql

  The caution is related to the variable initialization of your return 
parms.  If you
  want to return a character string greater than 30 characters in length, 
make sure
  you pre-allocate the string with spaces.  SQR will trunc it to 30 chars as 
this is
  their default, and they have no idea the length of the returned value.

  Also, this only works in later versions of SQR.  ie not in 2.27.  This is 
working on
  VMS 2.5.2.2, and Unix Sys 5 Rel 4  SQR 2.4.2.

Good Luck
John
 ----------
From: sqr-users
To: schindjf
Subject: Processing results fro a stored procedure
Date: Wednesday, November 02, 1994 5:43AM


     Is there a way to process rows or return values returned from a stored
     procedure in sqr?