Oracle integration

Write Octoparse scraped data to Oracle — Instant Client setup, schema/table-owner configuration, and upsert mode.

Write scraped data directly into an Oracle database. Requires the Oracle Instant Client to be installed on the machine running Octoparse.

Prerequisites

• Octoparse Standard plan or above
• Oracle 11g or later
• Oracle Instant Client (64-bit) installed — see below
• A user account with write permission on the target schema

---

Install the Oracle Instant Client

Octoparse uses Thick mode to connect to Oracle, so the Instant Client is required.

1. Download Instant Client Basic (64-bit) from Oracle’s website.
2. Extract it to a local directory (e.g. C:\oracle\instantclient).
3. Add that directory to the system PATH.
4. Restart Octoparse.

Note: the Instant Client architecture must match Octoparse (both 64-bit). Mismatched architectures throw DPI-1047.

---

Configure the export

Fill in the export settings in the following order:

Configuration name

Give the config a name so you can reuse it later. The dropdown lets you pick an existing config or type a new name to create one.

Connection details

Field	Description	Example
Server name	Database host (IP or domain)	192.168.1.100
Port	Port number	1521
Username	Database user	scott
Password	Database password	—
Table Owner	Schema (owner) the table belongs to	SCOTT

Octoparse assembles a connection string in the form {server}:{port}/{database} automatically.

Table Owner is required. In Oracle, tables belong to a specific schema — without Table Owner, Octoparse can’t query or write to the target. It’s usually the same as Username, but may differ when using a shared schema.

Database name

For Oracle, Database name is a free-text field (service name or SID) — there’s no dropdown.

Database Table

After filling in Database name, pick the target table from the Database Table dropdown (queried from user_tables). Create the table in the target schema ahead of time; Octoparse reads its columns for field mapping.

Test Connection

Click Test Connection to validate the connection, then click Export to start.

---

Write modes

Append (Insert)

Each export appends new rows to the end of the table without affecting existing data.

Upsert (Insert or Update)

Decides per row by the primary key you specify: update if the record exists, insert if it doesn’t. Designate the primary-key column in field mapping; if the target table needs a primary-key constraint, configure it in Oracle ahead of time.

---

Common errors

Error	Cause	Fix
DPI-1047	Instant Client missing or wrong architecture	Install the 64-bit Instant Client and add it to PATH
ORA-12899	Value exceeds column length	Widen the column (ALTER TABLE ... MODIFY)
ORA-01017	Wrong credentials	Re-verify credentials
ORA-12541	Can’t reach the listener	Check host, port, and network connectivity
ORA-00942	Table or view doesn’t exist	Confirm Table Owner is correct