$ proc SAMPLE9.PC sqlcheck=semantics
Pro*c/c++: Release 11.2.0.1.0-production on Tue Jan 8 15:18:40 2013
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
System default option values taken from:/usr/local/oracle/product/11.2.0/dbhome_1/precomp/admin/pcscfg.cfg
Error at line $, column in file sample9.pc BEGIN calldemo.get_employees ....... ..... 1 pls-s-00201, identifier ' Calldemo. Get_employees ' must is declared Error at line, column, file sample9.pc BEGIN calldemo.get_employees. ................. 1 pls-s-00000, Statement ignored Semantic error at line, column, file Sample9.pc:BEGIN calldemo.get_em Ployees ....... 1 pcc-s-02346, PL/SQL found semantic errors
$
Error reason: You need to specify "Calldemo." Get_employees "of the owning user.
Workaround: Add Userid=name/[email protected] at precompilation (@remotedb is not required if you are connecting to a local database).
As the above example:
$ proc SAMPLE9.PC sqlcheck=semantics Userid=scott/tiger
Pro*c/c++: Release 11.2.0.1.0-production on Tue Jan 8 15:25:20 2013
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
System default option values taken from:/usr/local/oracle/product/11.2.0/dbhome_1/precomp/admin/pcscfg.cfg
$
Compile through!
Original address: http://blog.csdn.net/iw1210/article/details/8481409
Go pls-s-00201, identifier ' Calldemo. Get_employees ' must be declared pre-compilation error causes and solutions