Oracle APEX Barcode Integration
Generate high-quality 1D and 2D barcodes in your Low-Code applications using RESTful web services.
Security
Supports Oracle Wallet (SSL) and DBMS_NETWORK_ACL_ADMIN for secure HTTPS handshakes.
Connectivity
Leverage native APEX REST Data Sources for declarative, no-code connectivity.
Rendering
Output as Base64 strings for direct embedding in Interactive Reports and Classic Grids.
Step 1: Network & SSL Configuration
Because Oracle APEX runs within the database, the DB engine must be allowed to communicate with external domains. Ensure your Oracle Wallet contains the Barcodesoft SSL certificate.
BEGIN
DBMS_NETWORK_ACL_ADMIN.append_entry(
acl => 'barcode_access.xml',
host => 'www.barcodesoft.com',
lower_port => 443,
upper_port => 443,
privilege => 'connect');
COMMIT;
END;
Step 2: Fetching Barcodes via PL/SQL
Use the APEX_WEB_SERVICE package to fetch the barcode image. For performance, we recommend converting the binary response to Base64 to avoid complex BLOB handling in the UI.
FUNCTION get_barcode_b64(p_data IN VARCHAR2) RETURN CLOB IS
l_blob BLOB;
BEGIN
l_blob := apex_web_service.make_rest_request_b(
p_url => 'https://www.barcodesoft.com/barcode/v1/code128?data=' || apex_util.url_encode(p_data),
p_http_method => 'GET'
);
RETURN apex_web_service.blob2clobbase64(l_blob);
END;
Step 3: Display in APEX UI
To display the barcode in a Classic Report or Interactive Grid, set the column type to Plain Text and use an HTML Expression.
<img src="data:image/png;base64,#YOUR_BASE64_COLUMN#" style="width:200px;height:auto;" />
apex_util.url_encode on the data parameter to handle special characters in product SKUs or serial numbers.
Ready to automate your Oracle APEX workflow?
Our support engineers can assist with complex GS1-128 or Data Matrix requirements specifically for Oracle environments.