I have existing procedures/functions written in C++ code; Can I reuse it in my StepSqlite PL/SQL package?
Yes. StepSqlite allows you to embed arbitrary code written in your ‘host-language’ into the PL/SQL code in your package between the [– and –] tags . This enables you to quickly reuse any code you already have to write stored procedures in StepSqlite database interface. Here are some things to note when embedding the host language code. Since PL/SQL is case insensitive, all procedure parameters and variables defined in PL/SQL part of the code must be referred to in embedded part of the code (between [– and –] tags ) as ALL CAPS. Here is an example which utilizes the existing C++ STL function for string replace to write a utility function which can be called from StepSqlite PL/SQL.
