The message below is from my oracle database.
I don't know why this message is occured.
I programmed usging proc on IRIX 6.5 and Oracle 8.1.7.0.
The application that I programmed is constist of many processes.
Each process opens a session when the process starts up.
The code below is the code for open a session for a process.
if(oracleConnectedFlag==FALSE){
EXEC SQL CONNECT :username IDENTIFIED BY :userpasswd AT :db_name USING :db_string;
oracleConnectedFlag = TRUE;
}
when I commit or rollback I used code below
EXEC SQL AT :db_name COMMIT;
or
EXEC SQL AT :db_name ROLLBACK;
Sometimes it works well but sometimes it generates below error message.
Bookmarks