Migrating to Splice*Plus

This topic details the Splice*Plus implementation of PL/SQL and describes any modifications that may be required to migrate your existing PL/SQL code to Splice Machine, in the following sections:

  • [SplicePlus Coverage](coverage) describes the basic language features as implemented in SplicePlus.
  • Data Type Conversions calls out any data type differences between Splice*Plus and other PL/SQL dialects, and how to accomodate to those differences.
  • Unavailable Features describes features that may not be available in Splice*plus and the workarounds for migrating those features.

Splice*Plus Coverage

   
Types
  • Numeric, string, date and time
  • Large object types
  • User-defined types: scalar, structure, table
  • Collections: Varrays, Nested Tables, Records
Conversions
  • Type casts
  • Value set conversions
Variables Declaration, initialization, assignment
Flow control IF, FOR, WHILE, RETURN, EXIT, GOTO, and so on
Functions,
Procedures
  • Named parameters with default values
  • Closures
  • Nesting
Arithmetic

On 7 different numeric forms.

On date and time types

SQL SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
Exceptions RAISE, Catch, custom definitions
Cursors OPEN, FETCH, BULK COLLECTION, %ROWCOUNT
Execution EXECUTE IMMEDIATE
Transactions Transaction stack

Data Type Conversions

Some of the data types in PL/SQL are not part of Splice Machine SQL; however, our PL/SQL compiler automatically converts such data types into native, Splice Machine SQL data types, including these conversions:

PL/SQL data type Splice Machine data type Notes
     
     
     
     
     

Splice*Plus: Features Not Available