Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PRC*C SQLCHECK=SEMANTICS must be given ?

Re: PRC*C SQLCHECK=SEMANTICS must be given ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 15 Oct 1998 13:49:59 GMT
Message-ID: <3626fd38.3772053@192.86.155.100>


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  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US