当前位置: 代码迷 >> Oracle开发 >> PROC编译报错PLS-S-00201
  详细解决方案

PROC编译报错PLS-S-00201

热度:125   发布时间:2016-04-24 07:30:36.0
求助PROC编译报错PLS-S-00201
Error at line 61, column 9 in file test.pc
  EXEC SQL insert into ticket(lkey,tknb,surn) values(1111111,'479000000
0000','#AuditTest' );
........1
PLS-S-00201, identifier 'TICKET' must be declared
Error at line 61, column 9 in file test.pc
  EXEC SQL insert into ticket(lkey,tknb,surn) values(1111111,'479000000
0000','#AuditTest' );
........1
PLS-S-00000, SQL Statement ignored
Semantic error at line 61, column 9, file test.pc:
  EXEC SQL insert into ticket(lkey,tknb,surn) values(1111111,'479000000
0000','#AuditTest' );
........1
PCC-S-02346, PL/SQL found semantic errors
*** Error code 1
make: Fatal error: Command failed for target `test.o'

请大家指教,谢谢了

------解决方案--------------------
不知道你有没有建ticket表,如果建了的话,就在编译的时候这样编译一次:proc iname=test.pc userid=用户名/密码,这样编译可能会出现很多错误,但是再次进行make的时候可能就好了,
  相关解决方案