It is similar to PL/SQL of ORACLE.
Call Proc in Embedded-SQL
- APRE doesn't support functionality as follows.
- ALTIBASE HDB doesn't support returning array-result.
- ALTIBASE HDB doesn't support a external procedure. (like procedure that it is stored in library-files)
Difference from ORACLE in Procedure
If you execute a procedure having DML statement in auto-commit mode, you can search records affected after execution of procedure is complete.
If you want to do it with ORACLE-style, you have to execute a procedure after change to Non-Autocommit mode in your session.