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