PROCEDURE pro_trans_one(in_kcbm number)
is
begin
for destine in (select * from Exam2where kcbm=in_kcbm) loop
insert into cc2user.exam2(
DESTINE_NO,
location_flag,
lsh,
id_card_no,
student_name,
zjcx,
school_id,
school_name,
exam_date,
shift_no,
state,
exam_result,
ZT,
tj,
tjrq,
jy,
lastupdatetime,
syn_flag,
tran_flag,
tran_date
)
values
(
530741,
1 ,
0,
'4128221' ,
'aa' ,
'aa',
30 ,
'aaa',
sysdate ,
102 ,
0 ,
-1 ,
1 ,
'' ,
sysdate ,
1 ,
sysdate ,
'1C' ,
1 ,
sysdate
);
end loop;
end;在线等高手指教,,执行时 报表或视图不存在的错。cc2user有写入权限 我执行单条insert时 可以正确执行 放到存储过程中就报错
is
begin
for destine in (select * from Exam2where kcbm=in_kcbm) loop
insert into cc2user.exam2(
DESTINE_NO,
location_flag,
lsh,
id_card_no,
student_name,
zjcx,
school_id,
school_name,
exam_date,
shift_no,
state,
exam_result,
ZT,
tj,
tjrq,
jy,
lastupdatetime,
syn_flag,
tran_flag,
tran_date
)
values
(
530741,
1 ,
0,
'4128221' ,
'aa' ,
'aa',
30 ,
'aaa',
sysdate ,
102 ,
0 ,
-1 ,
1 ,
'' ,
sysdate ,
1 ,
sysdate ,
'1C' ,
1 ,
sysdate
);
end loop;
end;在线等高手指教,,执行时 报表或视图不存在的错。cc2user有写入权限 我执行单条insert时 可以正确执行 放到存储过程中就报错
PROCEDURE pro_trans_one(in_kcbm number)
authid current_user试试这个