oracle调用array参数存储过程

-- Non-scalar parameters require additional processing files tyt_gas2014_search; temp tyo_gas2014_search:=tyo_gas2014_search(‘CREATOR‘,1,‘test‘,1); temp1 tyo_gas2014_search:=tyo_gas2014_search(‘CREATETIME‘,4,‘2015/4/17 0:00:00‘,3); temp2 tyo_gas2014_search:=tyo_gas2014_search(‘CREATETIME‘,3,‘2015/6/18 0:00:00‘,3); begin -- Call the procedure files := tyt_gas2014_search(); files.extend(3); files(1):= temp; files(2):= temp1; files(3):= temp2; pkg_gas2014_pagehelp.p_gas2014_gettablepagewhere(files => files, sqlwhere => :sqlwhere); end;

 

oracle调用array参数存储过程

标签：

本文系统来源：http://www.cnblogs.com/qtchao520/p/4588158.html

【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！