One procedure do wee in SQL developer but error during exceute it under sqlplus command line:

Remember add below in first line and last line:

 prompt Compiling procedure PROJ_xxx_xxx ------ this is the first line

/ -------- this is the last line tell sqlplus to run the procedure into DB now