记住这个错误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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9533994/viewspace-1020098/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9533994/viewspace-1020098/