Re: PL/SQL and Arrays

ias_at_magi.com wrote:
>
> Is there anyway using ANY version of PL/SQL that will allow me to pass
> result sets (arrays), back to my users?
>
> The arrays that are to be returned are of variable size (number of
> records), does the cause more problems?
>
> If not arrays, can I pass records back to the users somehow?
>
> Thats a lot of questions, I would really like an answer, please help.
>
> Thanks,
>
> Ian Abramson

Dear Ian:

Records groups is what arrays are called. You can define them in PL/SQL or pass a query from a report, form or graphic to PL/SQL.

Here are just some of the PL/SQL record group built-ins to look up in your PL/SQL reference.

CREATE_GROUP
CREATE_GROUP_FROM_QUERY
ADD_GROUP_COLUMN
DELETE_GROUP_ROW
POPULATE_GROUP_WITH_QUERY
POPULATE_GROUP

SET_GROUP_NUMBER_CELL
SET_GROUP_DATE_CELL
SET_GROUP_CHAR_CELL
GET_GROUP_ROW_COUNT
GET_GROUP_SELECTION
GET_GROUP_SELECTION_COUNT

Have fun!

I went to the Oracle class "Integrate the Developer/2000 Tools" and we went over these and many more ways to pass stuff back and forth. You might want to consider that if you can't fingure out record groups.

Regards,
Jennifer Received on Sat Sep 21 1996 - 00:00:00 CEST