hi all

I am calling a procedure within script.Even if the prcoedure is not executed successfully. In log file it is recorded as procedure successfully executed .How to capture errors in log file if the procedure is not executed in unix script

$SQP $clf_user_name/$clf_password@$db_server <<EOF> file_out_before.log
exec BatchImportCursor('$criteriano','$filename')

commit;

EOF

but when i execute procedure in backend it gives me an error invalid sql statemetns or numeric or value error.These error has to be recorded in log file.Any errors in database is not geting recorded in log file.How to record databse errors.


Help please

Try that.


Cheers,
Tink

hi
the above code mentioned does not capture the details in log file
my procedure is like
CREATE OR REPLACE PROCEDURE BatchImportCursor(CRITERIA_NUMBER VARCHAR2 , FILE_NAME VARCHAR2) IS
begin
:
:
exception when others
:
:
end


should i need to place wheneve sqlerror exit 1 like those of codings in script.How to capture oracle errors in script

hi
The above statement worked by setting the serveroutput on.

Thanks

but when i try to load text file into database using sqlloaer

sqlldr username/password@db control=control.ctl log=error.log


if i give table name wrong in control file TAble does not exists does error msg not getting recorded how to solve it.