Hello I am having a problem with a script. I try to run a store procedure from unix with sqlldr and shows me the following error.
begin
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "RNP.SP_ARCH_SALIDA", line 64
ORA-06512: at line 2
The sp creates a data file with a table. Run the script as a parameter by sending the directory where you saved the file. If I taste the TOAD enviendole sp from the directory as a parameter showing the script, works and creates the file
Script:
work=/work/input/telefonia
BASE=rnp/rnp@sinti9d
. profile.sinti9d
sqlplus -s $BASE <<EOF
set serveroutput on
spool salida.txt
begin
sp_arch_salida('/work/input/telefonia/prueba');
end;
/
spool off
EOF
From already thank you very much