Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pro*C sample file

Status
Not open for further replies.

GT98SVO

Programmer
Jan 10, 2001
25
US
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00201, identifier 'CALLDEMO.GET_EMPLOYEES' must be declared
Error at line 116, column 19 in file sample9.pc
BEGIN calldemo.get_employees
..................1
PLS-S-00000, Statement ignored
Semantic error at line 116, column 13, file sample9.pc:
BEGIN calldemo.get_employees
............1
PCC-S-02346, PL/SQL found semantic errors

New to Oracle Pro*C. I am getting these same three errors for numerous files I have written and sample files. I am thinking it is a config. error. Either in the ProZ*C config or the proc command-line.

Any suggestions?


 
It is not recognizing calldemo.get_employees Either the user throught which you are logging into oracle doesn't have the access to calldemo.get_employees or it could be the object (calldemo.get_employees )is not existing in the database.

Hope this helps.
Shantha. Talent is what you possess;
genius is what possesses you

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top