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