读书人

PROC编译报错PLS-S-00201

发布时间: 2012-05-27 05:42:30 作者: rapoo

求助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'

请大家指教,谢谢了

[解决办法]
怀疑是你的oracle实例中没有ticket这个对象。
试一下带这个参数编译,关闭预编译时的SQL语义检查:
proc SQLCHECK=SEMANTICS
[解决办法]
Error at line 61, column 9 in file test.pc

读书人网 >C语言

热点推荐