Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents


Overview

A stored procedure(PSM, ALTIBASE stored procedures(Persistent Stored Modules, ALTIBASE Stored Procedures) 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 Procedures

Altibase Stored Procedures are procedures are very similar tool to the OracleORACLE's PL/SQL in concept. 

Stored Procedures are one procedures are one of database object comprising SQL statement, Control flow statement, exception handler, etc. 

Stored Procedures are created procedures are is 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” procedures” is sometimes used to refer to the stored procedures and stored functions collectively.

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 The ALTIBASE Stored Procedure's overall syntax is very similar to the OracleORACLE's PL/SQL statement. 

Basic syntax of the procedures used in OracleORACLE's PL/SQL is almost same with  Altibase Stored with  Altibase Stored Procedures,

So you  can easily convert the Oracle the ORACLE Procedure to the Altibase Procedure  the ALTIBASE Stored Procedure except for some function which is functions which are not supported in the Altibase the ALTIBASE HDB.

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

Altibase Stored ALTIBASE Stored Procedures can be made with 'CREATE PROCEDURE' and 'CREATE FUNCTION' statement that has synax of Oracle ORACLE Procedure.

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