PCC-F-02104, Unable to Connect to Oracle When Precompiling And Not Using a Password

(Doc ID 1326948.1)

Last updated on MARCH 23, 2017

Applies to:

Precompilers - Version to [Release 10.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 23rd Mar 2017 ***


When precompiling with SQLCHECK=SEMANTICS it is required to connect to the Database in which the USERID option contains the connection information.

When doing so, the PCC-F-02104 error is returned when only the username and dbname are used in the USERID parameter (no password) during precompiltaion.

The following illustrate an example. Notice that only the username (scott) and connect string (Connect1) is used. The password is not included.

> proc sqlcheck=SEMANTICS userid=scott@Connect1 iname=sample1

Pro*C/C++: Release - Production on Tue Apr 5 18:09:09 2011

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

System default option values taken from:

PCC-F-02104, Unable to connect to Oracle

Using the same format "scott@Connect1" works with SQL*Plus (sqlplus scott@Connect1).

The following combinations will work during precompilation




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms