Re: Q: Pro*C with PL/SQL error
Date: 1997/09/30
Message-ID: <34384eec.21009229_at_newshost>#1/1
It is not correct to use "oerr ora 2104" to try and translate this message (it was not an ORA error, but a PCC error, oerr pcc 2104 would be more appropriate but that info isn't available via oerr).
Anyway, the error is unable to connect to Oracle. This is proc the application telling you that you gave it a parameter "userid=user/pass_at_dbname" and it tried to use that to connect to oracle and could not.
In order to precompile static pl/sql code, proc wants to have 2 parms set:
sqlcheck=semantics
userid=user/pass_at_db
You must have an incorrect setting for userid=..... For example:
$ proc iname=test sqlcheck=semantics userid=tkyte/wrong
Pro*C/C++: Release 8.0.3.0.0 - Production on Tue Sep 30 15:19:41 1997
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System default option values taken from: /usr/oracle/oracle8/precomp/admin/pcscfg.cfg
PCC-F-02104, Unable to connect to Oracle
$ proc iname=test sqlcheck=semantics userid=tkyte/tkyte
Pro*C/C++: Release 8.0.3.0.0 - Production on Tue Sep 30 15:19:46 1997
(c) Copyright 1997 Oracle Corporation. All rights reserved.
System default option values taken from: /usr/oracle/oracle8/precomp/admin/pcscfg.cfg
$
the first one failed, the second one logged in and worked.
Tue Sep 30 15:13:56 EDT 1997
(tkyte_at_aria) /export/home/tkyte/src/test
>
On 30 Sep 1997 11:22:03 -0400, gsa_at_panix.com (Gary Assa) wrote:
>I get an error while trying to compile a Pro*C program with PL/SQL code
>embedded in it. I am connecting the same way I do for regular Pro*C programs,
>but I get this unusual error and don't know what it means.
>
>(1) PCC-F-02104, Unable to connect to Oracle
>
>*** Error code 1
>make: Fatal error: Command failed for target `move_artsnew.o'
>
>I then did an oerr to see if this error had any more info, and surprisingly,
>it looks like 2104 IS a Pro*C error, but that didn't help me one bit.
>
>oerr ora 2104
>02104, 00000, "PCC: inconsistent host cache (no cuc available)"
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 30 1997 - 00:00:00 CEST