sqlerrm and sqlcode doubt(S)
439412Sep 11 2005 — edited Sep 11 2005Hi,
well sqlerrm and sqlcode are functions, so while handing exceptions raised we can use the return values, but at the same time i cannot use it in a sql query, what is the reason behing it?, see the following piece of code,
x := sqlcode;
error_message := sqlerrm;
works, but
select sqlcode,sqlerrm into x,error_message from dual, when specified in the exception handling part, woudn't work?
why is it so???
cheere