Skip to content
APEX Project Eye Docs

LOB2Script Utility

The LOB2Script Utility in APEX Project Eye provides a streamlined solution for handling Large Objects (LOBs) in your Oracle database. This specialized tool addresses the common challenge of incorporating BLOB and CLOB data into deployment scripts, making it significantly easier to manage, version, and deploy applications that utilize binary or large text content.

Key Benefits

Section titled “Key Benefits”
  • Simplified Deployment: Generate ready-to-use PL/SQL scripts for deploying LOB data
  • Version Control Integration: Include binary files in your version control system via text-based scripts
  • Cross-Environment Consistency: Ensure LOB data is identical across development, test, and production environments
  • Time Saving: Eliminate manual LOB handling processes that are error-prone and time-consuming
  • Application Portability: Package your entire application, including LOB data, in portable installation scripts

How It Works

Section titled “How It Works”

The LOB2Script Utility converts binary and large text data into deployable PL/SQL scripts:

  1. Select Source: Choose to upload a file or read from an existing LOB column in the database
  2. Configure Target: Specify the target table, column, and identifying WHERE condition
  3. Generate Script: The utility creates a PL/SQL script that will insert or update the LOB data
  4. Deploy: Execute the generated script in your target environment to deploy the LOB data

LOB2Script Utility Interface

The output is a SQL script you can add to your install scripts

File Upload Mode

Section titled “File Upload Mode”

Upload files directly from your local system:

  • File Selection: Choose any file from your computer to convert
  • Direct Conversion: Convert the uploaded file directly to a deployment script

Database Read Mode

Section titled “Database Read Mode”

Extract LOB data from existing database records:

  • Table Selection: Choose the source table and LOB column
  • Record Identification: Specify the WHERE clause to identify the source record
  • Preview: View basic information about the selected LOB before generating the script
  • Multiple Selection: Generate scripts for multiple LOB columns or records

Database Read Mode

Select LOB data from existing database tables to generate installation scripts

Common Use Cases

Section titled “Common Use Cases”

The LOB2Script Utility is particularly valuable for:

  • AOP Templates: Include APEX Office Print templates in your application installation scripts
  • Image Storage: Deploy application images stored in database LOB columns
  • Document Management: Handle document storage and retrieval in BLOB columns
Section titled “Related APE Features”