procedure result sets and Gupta/Centura

I am told that Oracle stored procedures (functions and procedures both in packages and living outside of them) returning result sets as arrays makes populating table windows rather messy.

My prior experience with SQL Windows was against Sybase, and Sybase more or less allows one to have input and output variables to procedures and then, almost as a side effect, would be the result sets from any queries executed within the stored procedure. The Sybase scenario worked fine with SQLW, but I am apparently going to need to add support for the Oracle method to my table base classes (we are using BuildingBlocks and atop this will be our own "corporate layer"). I am curious as to how other Centura developers using Oracle have dealt with this issue. Anyone have any tips or resources?

Also, I spoke with an engineer at Oracle who said that the latest version of PL/SQL allows one to return PL/SQL pseudo tables. Does anyone know if this is possibly a better solution for my needs, and will Centura be able to do anything with this out of the box?

--> Courts Carter

courts_carter_at_broder.com Received on Wed Dec 18 1996 - 00:00:00 CST