PL/CSQL

CUBRID supports the development of stored functions and procedures using PL/CSQL (Procedural Language extension of CUBRID SQL). PL/CSQL is an extension of CUBRID SQL to a procedural language, supporting procedural language features such as conditional statements, loops, variables, error handling, and modularization through internal procedures/functions, which are difficult to implement with declarative SQL alone. Of course, SQL statements can be included and used together within a PL/CSQL program.

• Overview
  • Creating Stored Procedures/Functions
  • Static SQL
  • Dynamic SQL
  • Writing Rules
  • Data Types
  • %TYPE
  • %ROWTYPE
  • Precision and Scale Specification Exceptions
  • Operators and Functions
  • Exception
  • System Configuration Parameters Application
• Declarations
  • Variable Declarations
  • Constant Declarations
  • Exception Declarations
  • Cursor Declarations
  • Local Procedure/Function Declarations
• Statements
  • BLOCK
  • Static SQL
  • Cursor Manipulation
  • RAISE_APPLICATION_ERROR
  • EXECUTE IMMEDIATE
  • Assignment
  • CONTINUE, EXIT
  • NULL
  • RAISE
  • RETURN
  • Procedure Call
  • IF
  • LOOP
  • CASE Statement
• Expressions
  • Literals
  • Identifiers
  • Result Count for Static SQL
  • Cursor Attributes
  • Binary Ops, Unary Ops, Parentheses
  • Record Field Reference
  • Function Call
  • CASE Expression
  • SQLCODE, SQLERRM