标准摘要
[中文适用范围]： 本国际标准ISO/IEC 9075的这一部分规定了用于在SQL服务器模块中声明和维护持久数据库语言例程的数据库语言的语法和语义。数据库语言包括： - 控制流语句的规范 - 将表达式结果赋值给变量和参数 - 条件处理程序的规范，允许SQL调用例程处理执行过程中出现的各种条件 - 信号和重新信号条件的语句规范 - 常驻SQL服务器游标的声明 - 局部变量的声明 还包括包含与SQL服务器模块和SQL调用例程相关的模式信息的信息模式表的定义。 [外文原描述]： ISO/IEC 9075-4:2016 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules. The database language for <externally-invoked procedure>s and <SQL-invoked routine>s includes: - The specification of statements to direct the flow of control. - The assignment of the result of expressions to variables and parameters. - The specification of condition handlers that allow SQL-invoked routines to deal with various conditions that arise during their execution. - The specification of statements to signal and resignal conditions. - The declaration of standing SQL-server cursors. - The declaration of local variables. It also includes the definition of the Information Schema tables that contain schema information pertaining to SQL-server modules and SQL-invoked routines.
英文名称Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)