Thursday, May 22, 2008

Pro*C !!!! Oooops!!!

Pro*C Home: $ORACLE_HOME/10gR2_db/precomp
=>which proc
/mnt/app/oracle/10gR2_db/bin/proc
=>proc b671908b.pc
Pro*C/C++: Release 10.2.0.1.0 - Production on Thu May 22 20:44:06 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
System default option values taken from: /mnt/app/oracle/10gR2_db/precomp/admin/pcscfg.cfg
Semantic error at line 38, column 13, file b671908b.pc:
   EXEC SQL EXECUTE
............1
PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used

Solution :
Compile as: proc b671908b.pc sqlcheck=semantics
or proc b671908b.pc userid=scott/tiger sqlcheck=semantics

No comments:

Post a Comment