Regarding log file

[ancys]

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

$SQP $clf_user_name/$clf_password@$db_server < 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.

Help please

[GIRAUD Fabien]

To redirect the error messages of a command line, you just have to add " 2> your_file " at the end of this line.

Hope this helps.

[ancys]

if i include 2 also
$SQP $clf_user_name/$clf_password@$db_server < file_out_before.log

the error msgs of procedure are not recorded.
But hte procedure shows error in backend like

returns more than one value of subquery
missing equal sign

Error msgs are got by exception handler in procedure.How to redirect these error msg to log file