Stored Procedures and Records.

[Speed]

I don't know if this has been asked before but is it possible to pass multiple records to a stored procedure?

The Oracle database guys here are writing some stored procedures to pass multiple records to a database and they want to know if I can pass records from a Delphi app (via DOA) to the stored procedures. Beats me.

Thanks.

Regards,

Steve

 

[Marco Kalter]

It depends on the data type used for the parameter(s):

A PL/SQL Table of a record type is not supported. Only PL/SQL Tables of scalar data types can be used, so you would have to pass multiple scalar tables representing the columns.

A collection object type can be used through the TOracleObject class. This allows you to pass Varray or Nested Table instances.