首先定义local table type:
CREATE TYPE <type_name> AS TABLE (<column_definition>[{,<column_definition>}...])
在定义存储过程时类似如下使用:
CREATE PROCEDURE <procedure_name> ( IN|OUT|INOUT <param_name> <type_name>, ... )
首先定义local table type:
CREATE TYPE <type_name> AS TABLE (<column_definition>[{,<column_definition>}...])
在定义存储过程时类似如下使用:
CREATE PROCEDURE <procedure_name> ( IN|OUT|INOUT <param_name> <type_name>, ... )
转载于:https://www.cnblogs.com/omygod/archive/2013/04/11/3013482.html