怎么在sqlplus调用输入参数为集合类型的包函数?---(index-by集合)
create or replace package testpkg is
type typetest is table of varchar2(10) index by binary_integer;
function insTest1(tTest in typetest )return number;
end testpkg;
--主体
create or replace package body testpkg is
function insTest1(tTest in typetest )return number
is
begin
insert into test values
(to_number(ttest(1)),ttest(2),ttest(3),to_number(tTest(4)),10);
return 0;
end insTest1;
end testpkg;
怎么在sqlplus调用输入参数为集合类型的包函数?-
===============
SQL> declare
2 type typetest is table of varchar2(10) index by binary_integer;
3 tTest typetest ;
lv number(5);
4 begin
5 tTest(1) :='1';
6 tTest(2) :='1';
7 tTest(3) :='1';
lv := testpkg.insTest1(tTest);
8 end;
9 /
=======
declare
v_tTest testpkg.typetest:=testpkg.typetest(1,2,3,4);
num number;
begin
num:=testpkg.insTest1(v_tTest);
dbms_output.put_line(num);
end;
/
为什么我这样做就不行,老会说testpkg.typetest不是个函数?????
分享到:
相关推荐
sqlplus 常用命令行参数,Oracle 中 sqlplus 初学者用的 常用命令行参数
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus 的即时客户端; oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm --补充包/文件,为运行ODBC环境附加库; ...
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.ziporacle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.ziporacle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.ziporacle-instantclient11.2-sqlplus...
instantclient-sqlplus-windows.x64-12.1.0.2.0.zip
oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_64.rpm oracle-instantclient-tools-21.6.0.0.0-1.x86_64.rpm oracle-instantclient19.10-basic-19.10.0.0.0-1.aarch64.rpm oracle-instantclient19.10-devel-19.10....
instantclient-sqlplus-windows.x64-11.2.0.4.0 instantclient-sqlplus-windows.x64-11.2.0.4.0
navicat登录oracle必须在其工具-选项-OCI中导入installclient的oci.dll和sqlplus,这是installclient的安装包,解压即可使用,对应navicat的版本是11.1
Oracle SQLplus常用的命令和函数
instantclient-sqlplus-win64-10.2.0.5 sqlplus oracle
instantclient-sqlplus-windows.x64-12.1.0.2.0 官方免费
instantclient-sqlplus32位, oracle网站总崩, 给需要的小伙伴
长度函数length 替换函数 replace 子串函数 substr sqlplus 基本命令
instantclient-sqlplus-win32-10.2.0.4.zip 实用的zip包
Oracle instantclient-sqlplus 64位系统使用,navicat连接数据库使用
instantclient-basic-nt-11.2.0.4.0/instantclient-sqlplus-nt-11.2.0.4.0
instantclient-sqlplus-linux.x64-11.2.0.4.0
instantclient-sqlplus-linux.x64-12.1.0.2.0.zip
instantclient-sqlplus-nt-11.2.0.3.0.zip instantclient-basic-nt-11.2.0.3.0.zip 链接: http://download.csdn.net/detail/lh11077/7727125 免安装客户端