|PCC-S-02345 - 11g Client to 10g Server [message #391566]
||Thu, 12 March 2009 10:33
Registered: March 2009
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:
/u01/app/oracle/product/11.1.0/client_1/bin/proc include=. include=/usr/include
01/include include=/u01/app/oracle/product/11.1.0/client_1/precomp/public includ
x-gnu ORECLEN=256 IRECLEN=256 CODE=ANSI_C userid=/ SQLCHECK=SEMANTICS iname=kms_
Pro*C/C++: Release 126.96.36.199.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
Error at line 72, column 2 in file kms_update_mof.pc
EXEC SQL SELECT
PLS-S-00000, SQL Statement ignored
Semantic error at line 72, column 2, file kms_update_mof.pc:
EXEC SQL SELECT
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:
Anyone have any ideas?
Thanks in advance for the help.