Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Question: ORA-01012: not logged on after successful (?) login

Question: ORA-01012: not logged on after successful (?) login

From: Tomasz Sidorkiewicz <humpel_at_willow.iie.pz.zgora.pl>
Date: Sat, 15 Aug 1998 19:39:57 GMT
Message-ID: <6r4o4r$unq$1@main.amu.edu.pl>


I'm trying to write simple program using precompilators. Please help. After connecting do database whatever I try to do (OPEN CURSOR, SELECT...), I got

ORACLE error-- ORA-01012: not logged on

I did it 3 lines before? What am I doing wrong?

EXEC SQL CONNECT :username IDENTIFIED BY :password AT :uuser USING :bazadanych;

    printf("\nConnected to ORACLE as user: %s\n", username);

EXEC SQL DECLARE salespeople CURSOR FOR

        SELECT title
            FROM articles;	

/*good so far....*/

/* Open the cursor. */

           EXEC SQL OPEN salespeople USING :bazadanych;

!!!!!!!!!!!!!!!!!!!!!!

error-- ORA-01012: not logged on

Thanks in advance.

Tomasz Sidorkiewicz Received on Sat Aug 15 1998 - 14:39:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US