A PL/SQL Table of records cannot be passed from the client to the server. You can only pass PL/SQL Tables of scalar data types. There are 2 options:

  • Modify the package procedure so that it only uses parameters of a PL/SQL Table of a scalar data type, or
  • Pass PL/SQL Tables of scalar data types to a PL/SQL Block, which then converts it to a PL/SQL Table of records and then calls the package procedure.


Marco Kalter
Allround Automations