Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PRC*C SQLCHECK=SEMANTICS must be given ?
A copy of this was sent to Arun Jamwal <arun_at_quality.com>
(if that email address didn't require changing)
On Wed, 14 Oct 1998 17:56:56 -0700, you wrote:
>
>Hi,
>I am trying to compile sample9 of pro*c demo but
>I get the following error. Any idea how to fix this?
>
>---------------------------------------------------------------------------------------------------------------------------------------------
>
>make -f proc.mk sample9
> proc iname=sample9.pc
>
>Pro*C/C++: Release 2.2.4.0.0 - Production on Wed Oct 14 17:43:21 1998
>
>Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
>System default option values taken from:
>/oracle/orahome/precomp/admin/pcscfg.h
>
>Semantic error at line 87, column 18, file sample9.pc:
> EXEC SQL EXECUTE
>.................1
>(1) PCC-S-02345, SQLCHECK=SEMANTICS must be given when embedded PL/SQL
>blocks are used
>
>make: 1254-004 The error code from the last command is 1.
>
>
>Stop.
>------------------------------------------------------------------------------------------------------------------------------------------------
>
>Thanks,
>Arun.
what platform are you on? when I run "make -f proc.mk sample9" on solaris 2.5.1 I get:
$ make -f proc.mk sample9
make -f proc.mk build OBJS=sample9.o EXE=sample9 make[1]: Entering directory `/user2/oracle73/precomp/demo/proc' sqlplus scott/tiger @../sql/calldemo </dev/null
SQL*Plus: Release 3.3.4.0.1 - Production on Thu Oct 15 09:27:20 1998
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to:
Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data options
PL/SQL Release 2.3.4.0.0 - Production
Package created.
Package body created.
SQL> Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production
With the distributed, replication, parallel query and Spatial Data options
PL/SQL Release 2.3.4.0.0 - Production
proc sqlcheck=full userid=scott/tiger dbms=v6_char iname=sample9.pc
Pro*C/C++: Release 2.2.4.0.0 - Production on Thu Oct 15 09:27:33 1998
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
System default option values taken from: /user2/oracle73/precomp/admin/pcscfg.h
It ran sqlplus to install the needed package and then precompiled the code with the sqlcheck and userid options....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 15 1998 - 08:49:59 CDT