Help: PowerBuilder/PLSQL Interface

I have the following package available:

Package P is

   type Err_List_Type is table of Table_A.Err_Code%Type Index by . . .

  procedure Validate (The_Rec     in  Table_B%Rowtype,
                      The_Errors  Out Err_List_Type);

end P;

and would like to make it available to PB (5.0) programmers on my project. The PB S/W has a screen that reflects the components of a single row of Table_B. I would like for them to capture the information and
send it to me on the server side for validation.

I know that I will most likely need to write a filter stored procedure.  However, the Table (Table_B) has over 100 fields.

1. Is there some way, short of having 100 ‘in’ parameters and 1 ‘out’ parameter, to solve this problem?
2. Can I pass a table value back to a PB calling routine?

TIA Dick Bolz Received on Mon Jul 28 1997 - 00:00:00 CEST