0

I am using HP-UX aCC compiler [HP C/aC++ B3910B A.06.26] to compile an old C/Pro*C application (already compiled with an older version of aCC compiler). The compilation is always failing with the below error 

 Pro*C/C++: Release 10.2.0.4.0 - Production on Sun Apr 28 12:01:34 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

System default option values taken from: /data/oracle/product/10.2.0/db_1//precomp/admin/pcscfg.cfg

PCC-I-02106, Userid only used when SQLCHECK = FULL, userid ignored.
Semantic error at line 252, column 9, file ToolDb.pcpp:
        EXECUTE
........1
PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are us
ed
gmake: *** [ToolDb.c] Error 1

As I understood, the compiler cannot recognize the proc *C keyword "EXECUTE" used to call a database stored procedure!

Any idea please that can help tp solve this issue? Thank you very much in advance. Regards

EvilTeach
  • 28,120
  • 21
  • 85
  • 141
jamel
  • 303
  • 2
  • 7
  • 16
  • Is it "Execute" (as in your title) or "EXECUTE" (as in the error message)? In any case, the error message "SQLCHECK=SEMANTICS must be given ..." probably tells you how to fix the problem. I don't know Pro*C, so I can't be sure of that. (There doesn't seem to be a tag for Pro*C, or I would have added it.) – Keith Thompson May 21 '13 at 16:00
  • It was a makefile issue, thnak you very much! :) – jamel May 24 '13 at 17:00
  • 1
    @keith oracle-pro-c is the tag – EvilTeach Jan 17 '15 at 03:51

2 Answers2

0

Add SQLCHECK=SEMANTICS to your Proc execute command

Al-Mustafa Azhari
  • 850
  • 1
  • 9
  • 24
0

It is not something like Pro*C compiler is not identifying the EXECUTE command. Whenever there is error in PL/SQL block first word is displayed. There might be some issue inside the PL/SQL. It would be helpful if we can have the PL/SQL block.

Singh Gaurav
  • 147
  • 3
  • 12