Hello everyone
I have a Pro*C file upgraded from Oracle10 to 19c.
In Oracle10 I use "proc USERID=aaa/bbb SQLCHECK=SEMANTICS ..." to compile the .pc file, the proc will connect to the ORACLE_SID database, but when compiling the file in 19c, it reports "PCC-02104Unable to connect to Oracle" error, meaning The username or password is invalid. I changed the compile command to "proc USERID=aaa/bbb@ccc SQLCHECK=SEMANTICS ... " and tried again, and it was successful, because I used @ccc to specify the database to connect to.
Does 19c not support using ORACLE_SID to connect to the database? If yes, is there any documentation about it? I really need this, because this problem is just my test, no official instructions