5.8. PROCEDURE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 5.8.1. CREATE PROCEDURE . . . 8.2. ALTER PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154 5.8.3. CREATE OR ALTER PROCEDURE . . . . . 5.8.4. DROP PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157 5.8.5. RECREATE PROCEDURE . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . 55 3.8.3. PSQL Source for SHOW_LANGS, a procedure involving an array . . . . . . . . . . . . . . . . . . . . . . . . . 56 3.9. Special Data Types 5.8. PROCEDURE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189 5.8.1. CREATE PROCEDURE . . . 8.2. ALTER PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 5.8.3. CREATE OR ALTER PROCEDURE . . . . .

.................. 171 PROCEDURE ........................................................................................................................ 171 CREATE PROCEDURE ....................... ................................................................................... 175 ALTER PROCEDURE ............................................................................................... ......................................................................... 179 CREATE OR ALTER PROCEDURE ............................................................................. 179 Примеры ....

5.8. PROCEDURE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176 5.8.1. CREATE PROCEDURE . . . 8.2. ALTER PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 5.8.3. CREATE OR ALTER PROCEDURE . . . . . 5.8.4. DROP PROCEDURE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 5.8.5. RECREATE PROCEDURE . . . . . . .

FILTER DECLARE FILTER INDEX CREATE INDEX PROCEDURE CREATE PROCEDURE ALTER PROCEDURE CREATE OR ALTER PROCEDURE DROP PROCEDURE RECREATE PROCEDURE SEQUENCE или GENERATOR CREATE SEQUENCE CREATE параметров Домены вместо типа данных TYPE OF COLUMN в объявлениях параметров и переменных EXECUTE PROCEDURE INSERT INSERT ... DEFAULT VALUES Предложение RETURNING Разрешено использовать UNION в операторе Повторный вызов перехваченного исключения Поддержка пользовательского сообщения об ошибке EXECUTE PROCEDURE 5 Руководство по языку SQL EXECUTE STATEMENT Без возврата данных Возврат одной строки

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 19.14. SHOW PROCedure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . DATABASE, DOMAIN, EXCEPTION, FILTER, FUNCTION, GENERATOR, GRANT, INDEX, PACKAGE, PROCEDURE, ROLE, SQL DIALECT, SYSTEM, TABLE, TRIGGER, VERSION, USERS, VIEW EXIT which is being used to terminate the SQL commands being entered. SQL> set term ~ ; SQL> create procedure test_proc (iInput integer = 666) CON> returns (oOutput integer) CON> as CON> begin CON> oOutput

nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure @1 does not return Dbkey not available for multi-table views -170 335544512 prcmismat Input parameter mismatch for procedure @1 -170 335544619 extern_func_err External functions cannot have more than 10 Firebird 2.1 Error Error Codes parameters -170 335544850 prc_out_param_mismatch Output parameter mismatch for procedure @1 -171 335544439 funmismat Function @1 could not be matched -171 335544458 invalid_dimension Column

nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure %s does not return mismatch for procedure %s -170 335544619 extern_func_err External functions cannot have more than 10 parameters -170 335544850 prc_out_param_mismatch Output parameter mismatch for procedure %s -171 335544439 is not defined Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -204 335544511 prcnotdef Procedure %s is not defined -204 335544515 codnotdef Status code %s unknown -204 335544516 xcpnotdef Exception

nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure does not no_dbkey Dbkey not available for multi-table views -170 335544512 prcmismat Parameter mismatch for procedure -170 335544619 extern_func_err External functions cannot have more than 10 parameters -204 335544509 charset_not_found CHARACTER SET is not defined -204 335544511 prcnotdef Procedure is not defined -204 335544515 codnotdef Status code unknown -204 335544516 xcpnotdef

THEN NEW.my_number = GEN_ID(my_generator, 1); END Переход с MS SQL на Firebird 10 CREATE PROCEDURE get_my_generator RETURNS (new_value INTEGER) AS BEGIN new_value = GEN_ID(my_generator, 1); END следующие части кода. /* MS-SQL */ CREATE PROCEDURE my_procedure AS DECLARE @my_variable int SET @my_variable = 5 /* Firebird */ CREATE PROCEDURE my_procedure AS DECLARE VARIABLE my_variable int; BEGIN значение. /* Это исходный оператор MS SQL, использующий традиционную базу данных pubs. */ CREATE PROCEDURE list_states AS SELECT Переход с MS SQL на Firebird 14 CASE state WHEN 'CA' THEN 'California'