Runs on: Windows

Print labels straight from an Oracle database

Oracle usually sits at the centre of the systems that already know what needs a label — work orders, lots, batches, shipments. LabelInn connects through the Oracle listener, runs your query and prints one label per row.

Download free See pricing

Who this is for

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

How it works

  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.

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

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.

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.

Try it with your own Oracle data

Start on the free plan, print a real label, and only pay when you want LabelInn to run the job for you.

Download free See pricing