Just a small question.
I have a pro*C which takes in a dynamic query and connects to oracle, fetches the data and then prints the o/p
When an error is detected these are the lines of code there
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("\nORACLE error detected:");
printf("\n% .70s \n", sqlca.sqlerrm.sqlerrmc);
EXEC SQL ROLLBACK WORK RELEASE;
exit(EXIT_FAILURE);
There is a vortex script which calls this pro*C
Now when i give in a wrong query ... (the table doesnt exist, i gave in the wrong table name), and then pass it to this pro*C from vortex script
The Err flag is not set
Instead $ret.oerr is set as "118 <EXEC> command sh returned exit code 1"
My question is .. why isnt the error flag $err and $errnum not being set here.
Isnt this an error?
I have a pro*C which takes in a dynamic query and connects to oracle, fetches the data and then prints the o/p
When an error is detected these are the lines of code there
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("\nORACLE error detected:");
printf("\n% .70s \n", sqlca.sqlerrm.sqlerrmc);
EXEC SQL ROLLBACK WORK RELEASE;
exit(EXIT_FAILURE);
There is a vortex script which calls this pro*C
Now when i give in a wrong query ... (the table doesnt exist, i gave in the wrong table name), and then pass it to this pro*C from vortex script
The Err flag is not set
Instead $ret.oerr is set as "118 <EXEC> command sh returned exit code 1"
My question is .. why isnt the error flag $err and $errnum not being set here.
Isnt this an error?