I am creating an SP in oracle and I need to use spool, but it does not work for me, someone can help me please:
spool mysp.log
prompt prompt creates mysp prompt
create or replace procedure mysp ace variables .... cursor cur is sql query .... begin ...... end mysp;
spool off; exit