Laserfiche's Oracle Database connector allows you to select, insert, update, delete, and upsert records. It also allows you to call stored procedures in an Oracle database.
The Oracle Database connector uses OJDBC to communicate to the database and to manipulate the records. The connector provides the option to insert the SQL statement manually, or dynamically build the SQL Statement based on the input parameters. An OJDBC driver establishes a connection to the database through the connection. You can interact with the database, for example, to create a statement to execute SQL queries against tables. The connector also supports leveraging the Oracle Wallet feature for enhanced security.