Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

What's Altibase Procedures

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

Stored Procedures are one of database object comprising 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 PL/SQL 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 has synax of Oracle Procedure. For further information about these statements, please refer to 'Altibase Stored Procedure Manual'.(Altibase Stored Procedure Manual)

  • No labels