Hi managers,
I use Oracle 7.3.4 ans DU 4.0d and I have a little problem with a proc*c
program I wrote. I connect to an oracle database with a "/" (OPS$),
make some stuff, disconnect then sleep for a while, the sleep command
doesn't work and it happends only when I connect with "/", no problem with a
connection like "ropo1/pom_at_lpdev" intstead of "/". The problem occured
when I disconnect from the database.
Here what it's said in the sleep man page:
"If the sleep() function returns because the requested time has elapsed, it
returns 0 (zero)....", normal case.
"...If the sleep() function returns because it caught a
signal, the function returns the number of seconds remaining in the suspen-
sion." What signal? I think that when I disconnect from the database, a
signal is sent and catched by the sleep command. I catched all signals in my
original program and see nothing.
Here is the program I used has a test. Maybe someone get an answer.
BTW, no problem with Oracle 7.3.2 and DU 3.2g.
TIA!
#include <stdio.h>
#include <sqlca.h>
#include <unistd.h>
void main(int argc, char *argv[])
{
EXEC SQL WHENEVER sqlerror goto ErrOracle;
EXEC SQL WHENEVER sqlwarning goto ErrOracle;
while(1)
{
EXEC SQL CONNECT :argv[1];
printf("Connect:%s\n",argv[1]);
EXEC SQL COMMIT RELEASE;
printf("Deconnect\n");
printf("zzzz...\n");
sleep(10);
}
ErrOracle:
printf("Erreur:%d\n",sqlca.sqlcode);
}
Received on Wed Mar 17 1999 - 14:49:54 NZDT