return codes from oracle

[chirpyform]

Hi,

I am in great urgence to find a solution to the following problem :
I have several sql scripts that create / drop sequencers, index and constraints. It's imperitive that i can test the return code from these sql scripts to know whether I continue with the rest. Unfortunately the function drop gives a return code non-zero even when it works!!!!

Can anybody tell me how i can know if the return code is serious or not.

Thanks

Chris

 

[KenCunningham]

Is this a unix flavour return code? If it doesn't give the same code when it works and when it doesn't, you can code accordingly using $?. If it gives the same code ..... post back.

 

[LKBrwnDBA]

Use the "whenever sql error" command to set an identifiable return code when script fails:

WHENEVER SQLERROR EXIT 99;
-- Rest of script
EXIT 0;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb