create or replace function fun_yggstjone
(
v_projectId in tp_projectinfo.projectid%type,
v_date1 in tp_dayreport.reportdate%type,
v_date2 in tp_dayreport.reportdate%type,
v_workTypeIds in varchar2(1000)
)
各位高手请问上面这段语句,怎么老是报错(最后一个变量声明),换成下面的就不报错了,难道只能引用列的类型吗?请问原因,救急
create or replace function fun_yggstjone
(
v_projectId in tp_projectinfo.projectid%type,
v_date1 in tp_dayreport.reportdate%type,
v_date2 in tp_dayreport.reportdate%type,
v_workTypeIds in tp_worktype.worktypeid%type
)
(
v_projectId in tp_projectinfo.projectid%type,
v_date1 in tp_dayreport.reportdate%type,
v_date2 in tp_dayreport.reportdate%type,
v_workTypeIds in varchar2(1000)
)
各位高手请问上面这段语句,怎么老是报错(最后一个变量声明),换成下面的就不报错了,难道只能引用列的类型吗?请问原因,救急
create or replace function fun_yggstjone
(
v_projectId in tp_projectinfo.projectid%type,
v_date1 in tp_dayreport.reportdate%type,
v_date2 in tp_dayreport.reportdate%type,
v_workTypeIds in tp_worktype.worktypeid%type
)
(
v_projectId in tp_projectinfo.projectid%type,
v_date1 in tp_dayreport.reportdate%type,
v_date2 in tp_dayreport.reportdate%type,
v_workTypeIds in varchar2
)
-------------------------
这里不需要指定长度