One procedure do well 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