DEV Community

AntDB
AntDB

Posted on

AntDB-Oracle Compatibility Developer’s Manual P3–80

Stored Procedure Language

This chapter introduces the Stored Procedure Language - SPL, which is an efficient, procedural-oriented programming language. It is used to write user-defined stored procedures, functions, triggers, and packages for AntDB.
9205
The following are some of the features provided by the SPL language that are useful for developing applications.

  • As a complement to the SQL language, SPL adds fully procedural oriented programming features.

  • Provides a single common programming language for AntDB to create stored procedures, functions, triggers and packages.

  • Improves code reuse.

  • Easy to use.

This chapter first introduces the basic components of an SPL program, then provides an overview of the structure of an SPL program and how to create procedures or functions. The content on how to create triggers with SPL is different from the content in this chapter and requires a separate section for discussion.

The rest of this chapter delves into the details of the SPL language and provides examples of related applications.

Top comments (0)