I have a procedure(see attached) which gives an error at the point where i mentioned sqlplus copy command. Somebody help pls.
Error is
*********
ERROR at line 4:
ORA-06550: line 4, column 7:
PLS-00103: Encountered the symbol "FROM" when expecting one of the following:
:= . ( @ % ;'
DECLARE
BEGIN
IF (&CONDITION = 0) THEN
copy from acc/acc@acc to acc/acc@acc INSERT tcall_today using select * from call_today;
delete from call_today where term_date=&CONDITION
ELSE
copy from acc/acc@acc to acc/acc@acc INSERT tcall_today using select * from call_today where term_date=&CONDITION
delete from call_today;
END IF;
commit;
END;
/
exit
/
Bookmarks