Use the Structured Process Language (SPL) to write stored procedures, functions, triggers, and packages for .
SPL is a procedural programming language designed for Oracle compatibility. It extends SQL with control flow, variables, and modular code structures that Oracle developers rely on, requiring no changes to your Oracle-compatible stored procedure logic.
SPL supports the following capabilities:
Comprehensive procedural programming: Supplement the SQL language with control flow, variables, and modular code structures.
Full Oracle construct support: Write stored procedures, functions, triggers, and PL/SQL packages for the database.
Integrated development and testing: Develop and test stored procedures in a single environment without switching between tools.
Code reuse: Package related procedures and functions into reusable modules that other programs can call.
Ease of use: Write and maintain stored procedure logic with a familiar, developer-friendly syntax.
This chapter introduces the basic elements of an SPL program. It then describes program organization and explains how to create stored procedures or functions.