RE: [sqr-users] Calling a procedure that returns a REF Cursor

[Peter Burton <pburton@brio.com>]

Colin,

This functionality is planned to be in SQR 8.0.

Peter

-----Original Message-----
From: Colin Abbott [mailto:colin.abbott@mcgill.ca]
Sent: Thursday, October 24, 2002 10:03 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Calling a procedure that returns a REF Cursor


Hi,

   I am trying to call a stored procedure in our Oracle 8.1.7 database that 
returns the results as a REF Cursor OUT parameter.

   I am able to call it within a BEGIN-SQL block but only if it returns one 
row, if It returns more then one row I have to assign all the variables to 
an array and then in SQR use the array.

  looking through the documentation I came upon  BEGIN-EXECUTE  which is 
supposed to execute procedures that return rowsets and you can nest a 
BEGIN-SELECT within the BEGIN-EXECUTE to loop through all the rows that the 
procedure returns. This would be great except I can not get it to work, 
does anyone have an example of using BEGIN-EXECUTE to call an Oracle 
procedure?

Thanks
Colin
=======================================
Colin Abbott
Analyst (Finance)
Information Systems Resources
McGill University
E-mail: Colin.Abbott@MCGILL.CA
Fax: 1-514-398-8252
=======================================

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users