我测试怎么报错?????????
SQL> get c:\sql.sql
1* select * from tabs
SQL> get c:\exec.sql
1 create or replace procedure test_proc
2 is
3 begin
4 @c:\sql.sql
5* end;
SQL> @c:\exec.sql
6 /
警告: 创建的过程带有编译错误。
SQL> get c:\exec.sql
1 create or replace procedure test_proc
2 is
3 begin
4 @c:\sql.sql
5* end;
SQL> @c:\exec.sql
SQL> get c:\sql.sql
1* insert into wyj values(1);
SQL> get c:\exec.sql
1 create or replace procedure test_proc
2 is
3 begin
4 @c:\sql.sql
5* end;
SQL> @c:\exec.sql
SQL> get f:\dbms.sql
1* insert into wyj values(1);
SQL> get f:\proc.sql
1 create or replace procedure test_proc
2 is
3 begin
4 @f:\dbms.sql
5* end;
SQL> @f:\proc.sql
create or replace procedure test_proc
is
begin
@c:\sql.sql;
end;
Compilation errors for PROCEDURE CS.TEST_PROC
执行时就报以下错误
Error: PLS-00103: Encountered the symbol "@" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
Line: 4
Text: @c:\sql.sql;