Re: Pro*C :ORA-01012: not logged on
Date: 1998/03/15
Message-ID: <6eh788$pv9$1_at_comet2.magicnet.net>#1/1
The problem that you are encountering comes from the fact that when you are connecting to the database, you are using a named connection (i.e. AT DBNAME)...
However when you are trying to execute a SQL statement (i.e. EXEC SQL xxxxx) you are NOT telling Pro*C what connection to use. If you are only using 1 connection to the database, get rid of the AT clause from you connect line. Otherwise, use it EVERYWHERE.
Take Care,
Robert Clevenger
Jian R. Mei wrote in message ...
>Hi, every one:
>I am working on a project with pro*C/C++ v8.0.4.000. I integrated pro*C/C++
>with Visual C++ 5.0. Every thing looks fine. I just pick a sample from
>Oracle, sample6.pc and compiled it. Perfect! No error. I ran it, it
>connected to Oracle server.ok. but when it executed first SQL command, I
>got an error:ORA-01012: not logged on. It doesn't any sense to me.
>On my machine, I have a lot of oracle tools which can work without any
>problem!
Received on Sun Mar 15 1998 - 00:00:00 CET