Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

What's Altibase Procedures

...

Table of Contents


Overview

A stored procedures(PSM, Persistent Stored Modules) of ALTIBASE HDB might be divided into three as below.


  • Stored Procedure: With input, output and input/output parameters, A user can execute SQL statement with a predefined procedures inside a procedure by using it. It doesn't return a value and delivers a value to the client through output and input/output parameters.
  • Stored Function: Same as a procedure shown above, but it has one return value. Since it has return one value, it can be utilized as operand in an expression of SQL statement.
  • Typeset: It is a set of definition for user-defined types. In the main, it is chiefly used to exchange user-defined types with parameters or return value among stored procedures.

What's Stored Procedure

Stored procedure is very similar tool to the ORACLE's PL/SQL in concept. 

Stored Procedures is one procedure is one of database object that consist of  comprising SQL statement, Control flow statement, exception handler, etc. 

Stored Procedures are created procedure is created in advance, compiled, and stored in database, ready for execution.

In that state, stored procedures Stored Procedure can be simulaneously simultaneously accessed by multiple SQL statements.

The term “stored procedure” “Stored Procedure” is sometimes used to refer to stored procedures and stored functions the Stored Procedure and Stored Function collectively.

The Stored procedures Procedure and stored functions Stored Function differ only in that stored functions return Stored Function returns a value to the calling application, whereas stored procedures do the Stored Procedure does not.

Altibase The ALTIBASE Stored Procedure's overall syntax is very similar to Oraclethe ORACLE's PLSQL PL/SQL statement.  The

Basic syntax of Procedures the procedures used in OracleORACLE'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.Altibase Stored Procedures with  ALTIBASE Stored Procedure,

So you can easily convert the ORACLE PL/SQL to the ALTIBASE Stored Procedure except for some functions which are not supported in the ALTIBASE HDB.

We call these ALTIBASE Stored Procedure to the ALTIBASE PSM ( Persistent Stored Modules) with a different name.

ALTIBASE Stored Procedure can be made with 'CREATE PROCEDURE' and 'CREATE FUNCTION' statement that is same that has synax of Oracle Procedure. For more ORACLE PL/SQL.

For further information about these statementstatements, please refer to 'Altibase ALTIBASE Stored Procedure Manual'.(ALTIBASE Stored Procedure Manual)