自定义类型:
CREATE TYPE peopleOracleObject AS OBJECT
(
peopleOracleID NUMBER(8) ,
nameOracle varchar(50) ,
ageOracle Number(3)
)自定义数组类型:
CREATE TYPE people_Oracle_LIST AS VARRAY(500) OF peopleOracle ;存储过程:
CREATE OR REPLACE PROCEDURE NAD_SP_CreateWebCostToAd(
p_peopleArray IN people_Oracle_LIST,
p_ID IN number,
p_out OUT VARCHAR2)
.
.
.
请问,这样的存储过程,写测试代码时如果传参数?
CREATE TYPE peopleOracleObject AS OBJECT
(
peopleOracleID NUMBER(8) ,
nameOracle varchar(50) ,
ageOracle Number(3)
)自定义数组类型:
CREATE TYPE people_Oracle_LIST AS VARRAY(500) OF peopleOracle ;存储过程:
CREATE OR REPLACE PROCEDURE NAD_SP_CreateWebCostToAd(
p_peopleArray IN people_Oracle_LIST,
p_ID IN number,
p_out OUT VARCHAR2)
.
.
.
请问,这样的存储过程,写测试代码时如果传参数?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货