記住這個錯誤PLS-00103: 出現符號

SQL> DECLARE
2 devtype varchar2(256);
3 done boolean;
4 BEGIN
5 devtype:=sys.dbms_backup_restore.deviceAllocate (type=>'',ident=>'t1');
6 sys.dbms_backup_restore.restoreSetDatafile;
7 sys.dbms_backup_restore.restoredatafileto(dfnumber=>01,toname=>'D:ORACLEORADATAORA9ISYSTEM01.DBF');
8 sys.dbms_backup_restore.restoredatafileto(dfnumber=>02,toname=>'d:oracleoradataora9iUNDOTBS1.DBF');
9 sys.dbms_backup_restore.restoredatafileto(dfnumber=>03,toname=>'d:oracleoradataora9iDRSYS01.DBF');
10 sys.dbms_backup_restore.restoredatafileto(dfnumber=>04,toname=>'d:oracleoradataora9iEXAMPLE01.DBF');
11 sys.dbms_backup_restore.restoredatafileto(dfnumber=>05,toname=>'d:oracleoradataora9iINDX01.DBF');
12 sys.dbms_backup_restore.restoredatafileto(dfnumber=>06,toname=>'d:oracleoradataora9iTOOLS01.DBF');
13 sys.dbms_backup_restore.restoredatafileto(dfnumber=>07,toname=>'d:oracleoradataora9iUSERS01.DBF');
14 sys.dbms_backup_restore.restoredatafileto(dfnumber=>08,toname=>'d:oracleoradataora9iXDB01.DBF');
15 sys.dbms_backup_restore.restoredatafileto(dfnumber=>09,toname=>'d:oracleoradataora9iTEST02.DBF');
16 sys.dbms_backup_restore.restoredatafileto(dfnumber=>10,toname=>'d:oracleoradataora9iUSERS03.DBF');
17 sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'D:ORACLEORA92DATABASEKKBSNLS_1_1', params=>null);
18 sys.dbms_backup_restore.deviceDeallocate;
19 END；
20 /
END；
*
ERROR 位於第 19 行:
ORA-06550: 第 19 行, 第 5 列:
PLS-00103: 出現符號 "；"在需要下列之一時：
;

符號 ";在 "；" 繼續之前已插入。

做事還要認真和細心，就他奶奶的一個破'；',玩的我夠慘阿。

我再羅嗦一句：經驗他祖宗是教訓。

[@more@]