Introduction

Supported Oracle Database Objects

  • Package icon PL/SQL packages
  • Function icon PL/SQL functions
  • Procedure icon PL/SQL procedures

How the Connector Builders Work

  1. The Connector Builders read the Oracle data dictionary.
  2. They calculate dependencies and determine the types of attributes, parameters, and arguments.
  3. They generate all required Java infrastructure code to call Oracle PL/SQL programs.

Do Not Modify Generated Code

The Connector Builders are re-runnable and overwrite the generated Java code on every run. If you change a PL/SQL program signature (for example, add, remove, or rename parameters, or change their types), rerun the Connector Builders to regenerate matching Java accessor code.

Working Paradigm

The generated Java code provides service methods that send and receive transfer objects to and from PL/SQL programs.

  • Send data: Create transfer objects and pass them to PL/SQL programs.
  • Receive data: Call PL/SQL programs and receive transfer objects.
  • Mixed mode: Send and receive data in a single stored procedure call.

Transfer Object Model

  • Use transfer objects to bundle all data required for a single process or use case.
  • Data is processed in the database and transferred to/from the calling process in one step.
  • Transfer objects are short-lived: they are not cached, reused, or stored temporarily.