STARTER — $7.99/MO / 14-DAY PRO TRIAL ON SIGNUP

Print labels straight from an Oracle database

Connect LabelInn to Oracle through its listener on port 1521, bind query columns to label fields and print one thermal label per row. Data stays on your network.

Start free Download LabelInn
FREE PLAN · NO CREDIT CARD · WINDOWS / MAC / LINUX / WEB
DATABASE QUERYROWS TO LABELS
Print labels straight from an Oracle database — LabelInn
Native printer languagesZPL, TSPL, TPCL, ESC/Label
No driver to installUSB, network or Bluetooth
Every platformWindows, macOS, Android, web
Free to startNo credit card, 14-day Pro trial

HOW IT WORKS

Three screens from data to printed label.

No copy-paste, no hunting for templates. The same flow repeats for every record.

Database schema browser
01 / CONNECTConnect the database

Choose the engine, test the connection and browse the schema.

Running a query
02 / QUERYWrite one query

A named, parameterised query returns the rows a label needs.

Print dialog
03 / PRINTPrint straight from rows

Preview, pick the printer and print the result.

01

Who this is for

Manufacturing, pharmaceutical and distribution teams on Oracle-backed ERP or MES whose labelling is handled outside the system today.

02

Step by step

  1. Install the LabelInn Windows app and your Oracle client driver on the machine that will run the job.
  2. Add the Oracle connection: host, port 1521, database and a database user that can read the tables you need.
  3. Write the Oracle SQL query that returns exactly the rows you want to label, one row per label.
  4. Map each result column onto a label field — text, barcode, QR or RFID — then preview a few rows.
  5. Print the result set, or save the query so the next run is one click.
Choose the database type: LabelInn app screenshot
1Choose the database typeOracle, MySQL / MariaDB, PostgreSQL, Microsoft SQL Server and SAP HANA are supported.

Write ordinary Oracle SQL. Use FETCH FIRST n ROWS ONLY while you are testing so a preview never pulls the whole table.

Try it with your own data — signing up starts a 14-day Pro trial, no credit card. After that this feature needs Starter at $7.99/mo. Download now → | See pricing →

03

What you can do

  • Result columns bind to any label field, so barcode and QR content comes straight out of Oracle.
  • Re-run the saved query whenever you need the current rows — no export, no copy-paste, no stale file.
  • Mix database columns with static text, counters, dates and serial numbers on one label.
  • Printed rows are recorded in the print history, so a reprint or an audit can find the exact job later.
  • Queries can be parameterised, so an operator supplies a work order or batch number instead of editing SQL.

04

Technical details

EngineOracle
Default port1521
Query languageOracle SQL
Row limit syntax… FETCH FIRST n ROWS ONLY
DriverYour own ODBC/OLEDB/Oracle client driver
PlatformWindows desktop app
CredentialsStay on your machine; the query runs from your network

05

Requirements for a direct database connection

  • Direct database connections need the LabelInn Windows desktop app — the connector that loads real database drivers is a Windows sidecar, so this path is not available on macOS today.
  • You supply the Oracle client driver; LabelInn does not redistribute database drivers.
  • Point the connection at a read-only database user. LabelInn reads rows to fill labels — it should never need write access.
  • While you are testing, keep the query small with `… FETCH FIRST n ROWS ONLY` so a preview cannot pull an entire table.

06

Frequently asked questions

07

What we verified

The capability is implemented in the LabelInn codebase and the referenced source file names the exact format, engine, port or endpoint described on this page.

lib/models/database_connection.dart — DatabaseKind.oracle('oracle', 'Oracle', 1521), usesOracleListener

Other data sources: Excel · CSV · Microsoft SQL Server · MySQL / MariaDB · PostgreSQL

Printing from a different model? See all supported printers →

ANY PRINTER

Design it, bind your data, print on the printer you already own.

Zebra, TSC, Toshiba, Epson and more — over USB, network or Bluetooth, with no driver to install.

LabelInn on a laptop with a thermal printer and the printed label

PRICING

Start free. Pay when it earns its keep.

Compare every plan →

Free$0

Unlimited printing and templates, cloud sync, 30-day print history.

 Starter$7.99/mo

Excel and CSV binding, full print history, 2 PCs and 2 mobile devices.

 Pro$24.90/mo

Marketplace and shipping, API and webhooks, 5 PCs and 5 mobile devices.

QUESTIONS / FAQ

Frequently asked questions

Does label data leave my network when I print from Oracle?

The query runs from the machine you installed LabelInn on, against your own Oracle server. Credentials stay local. What leaves the machine is what you choose to sync — the label design and the print record.

Which Oracle SQL do I write?

Ordinary Oracle SQL. LabelInn does not rewrite your SQL; it runs the statement you saved and maps the result columns onto label fields. Use `… FETCH FIRST n ROWS ONLY` while testing.

Can I print to a Zebra or TSC printer from Oracle without a driver?

For models LabelInn drives natively over ZPL, TSPL or TPCL, yes — the command stream is generated and sent directly. That is independent of the database driver, which is only used to read your rows.

KEEP GOING

Related pages

NEXT STEP / LABELINN

Print your Oracle data on the printer you already own

This feature runs on Starter — $7.99/mo, or $79.90/year (pay for 10 months, use 12). Signing up starts a 14-day Pro trial, so you can bind your own Oracle data and print a real label before you pay anything. · 14-day Pro trial on signup · No credit card required · Windows, macOS, Android, Web

Start free →