Hai,

When we compile a procedure, if there is any error, it shows "Warning: Procedure created with compilation errors." We have to type explicitly, "show errors" in order to see the errors. Is there any way that the errors are shown implicitly after compilation?

It wont show errors during compilation. it will create procedure with errors.
there is no other way too. (other than show errors)

but when you execute that procedure, it will shows those error.

hi,
Really a good question. weel there is not a permanent solution. but u can do one thing, after the END stmnt. of procedure give a forward slash, and then write show err; and again give forward slash. and then compile the whole fiel, if some error is there it will display errors.

--write code here--
end procedure_name;
/
show err;
/

now compile whole file.

regards,
RSY

This looks better.
Thanks Raghav!!!

---------
Bhuvana

hi,

Bhuvana, click on the thanks button if u want to say thanks, that will add to my reputation.

ok, and one more thing, if u are using the suggestion which i gave, in real time, then remember one thing, i.e. to delete the show err; code from the file, before doing the checkin to the version control.

ok, do not forget this.

regards,
RSY