error in procedure
I have a procedure(see attached) which gives an error at the point where i mentioned sqlplus copy command. Somebody help pls.
ERROR at line 4:
ORA-06550: line 4, column 7:
PLS-00103: Encountered the symbol "FROM" when expecting one of the following:
:= . ( @ % ;'
My procedure is
define CONDITION = &1
-- display parameters
prompt CONDITION = "&CONDITION"
set arraysize 5000
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
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;
COPY is a sqlplus command, not a PL/SQL command.
Click Here to Expand Forum to Full Width