I am using a stored procedure in Oracle 11g. This stored procedure will copy a document between two servers (database and application) using Executecmdwithreturn (Command);
but when I run it I get this error:
Host key verification failed.
I already generated the key for the database server.
Command := 'scp ' || 'carpetaServidor1 '||' ' || '/carpetaServidor2';
Executecmdwithreturn(Command);
Looking at your code and at the error i "imagine" that the problem it's not in the PL/SQL but in the scp command invoked.
Please google "scp Host key verification failed".