Altibase Stored Procedures are very similar tool to the Oracle's PL/SQL in concept.
Stored Procedures are created in advance, compiled, and stored in database, ready for execution.
In that state, stored procedures can be simultaneously accessed by multiple SQL statements.
The term “stored procedure” is sometimes used to refer to the stored procedures and stored functions collectively. Stored
The stored procedures and stored functions differ only in that stored functions return a value to the calling application, whereas the stored procedures do not.
The Altibase Stored Procedure's overall syntax is very similar to the Oracle's PL/SQL statement. The
Basic syntax of Procedures the procedures used in Oracle's PL/SQL is almost same with Altibase Stored Procedures,
So you can easily convert the Oracle Procedure to the Altibase Procedure except for some function which is not supported in the Altibase HDB.
We call these Altibase Stored Procedure to Altibase to the Altibase PSM ( Persistent Stored Module ) with a different name.
Altibase Stored Procedures can be made with 'CREATE PROCEDURE' and 'CREATE FUNCTION' statement that has synax of Oracle Procedure.
For further information about these statements, please refer to 'Altibase Stored Procedure Manual'.(Altibase Stored Procedure Manual)