OraFAQ Forum: Precompilers, OCI & OCCI » PCC-S-02345

Home » Developer & Programmer » Precompilers, OCI & OCCI » PCC-S-02345 - 11g Client to 10g Server (on RHEL 5.0 x86_64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PCC-S-02345 - 11g Client to 10g Server [message #391566]

Thu, 12 March 2009 10:33

jerrys
Messages: 2
Registered: March 2009

Junior Member

Hi,

I'm new to this forum. I'm running an Oracle 11g Client and a 10g Server. Both are running on Linux versions RHEL 5.0 x86_64.

Before, I provide the contents of the error message, I wanted to mention that I have investigated the roles and privileges I have been granted for OPS$JERRYS and I have all the privileges granted to my MASTER role including connect. Yet I get the following error with the SQLCHECK=SEMANTICS flag set with a userid=/

Here's the text of the error:

Pre-compiling kms_update_mof.pc
/u01/app/oracle/product/11.1.0/client_1/bin/proc include=. include=/usr/include
include=/usr/include/Xm include=/s4root/operations/releases/ver_64_2009_02_21_r
01/include include=/u01/app/oracle/product/11.1.0/client_1/precomp/public includ
e=/usr/local/include/c++/4.3.1 include=/usr/local/include/c++/4.3.1/i686-pc-linu
x-gnu ORECLEN=256 IRECLEN=256 CODE=ANSI_C userid=/ SQLCHECK=SEMANTICS iname=kms_
update_mof.pc oname=kms_update_mof.c

Pro*C/C++: Release 11.1.0.6.0 - Production on Thu Mar 12 11:16:23 2009

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

System default option values taken from: /u01/app/oracle/product/11.1.0/client_1
/precomp/admin/pcscfg.cfg

Error at line 72, column 2 in file kms_update_mof.pc
EXEC SQL SELECT
.1
PLS-S-00000, SQL Statement ignored
Semantic error at line 72, column 2, file kms_update_mof.pc:
EXEC SQL SELECT
.1
PCC-S-02346, PL/SQL found semantic errors
make: *** [kms_update_mof.o] Error 1

When I have a 10g Client talking to a 10g Server I don't receive the pre-compiler error. The problem occurs with a 11g Client talking to a 10g Server.

The contents of $ORACLE_HOME/precomp/admin/pcscfg.cfg are:

sys_include=(/usr/include,/usr/include/XM,/usr/local/lib/gcc/x86_64-unknown-linux-g
nu/4.3.1/include,/usr/local/include/c++/4.3.1,/usr/local/include/c++/4.3.1/x86_64-u
nknown-linux-gnu)
ltype=short

Anyone have any ideas?

Thanks in advance for the help.

Jerry.

Report message to a moderator

Previous Topic:	OCI Query (merged)
Next Topic:	PCC-S-02346 - 11g (64 bit - RHEL 5.2) Client to 11g(32 bit - RHEL 5.2) Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 04:36:30 CST 2024