Skip to end of metadata
Go to start of metadata


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)

Sample Code

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.

  • No labels