What's Altibase Procedures
Altibase Stored Procedures is very similar tool to Oracle's PL/SQL in concept. Stored Procedures is one of database object that consists of SQL statement, Control flow statement, exception handler, etc. 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 stored procedures and stored functions collectively. Stored procedures and stored functions differ only in that stored functions return a value to the calling application, whereas stored procedures do not.
Altibase Stored Procedure's overall syntax is very similar to Oracle's PLSQL statement. The Basic syntax of Procedures used in Oracle's PL/SQL is almost same with Altibase Stored Procedures, So you can easily convert Oracle Procedure to Altibase Procedure except for some function which is not supported in Altibase.
We call these Altibase Stored Procedure to Altibase PSM ( Persistent Stored Module ) with a different name.
Altibase Stored Procedures can be made with 'CREATE PROCEDURE' and 'CREATE FUNCTION' statement that have synax of Oracle Procedure. For more information about these statements, please refer to 'Altibase Stored Procedure Manual'.