SQLPLUS COPY command

The COPY command in Oracle is a command implemented in SQL*Plus. I need to execute the COPY command from a Perl-script. This does not work, unless I say something like:

        system('echo "COPY FROM....."|sqlplus -s username/password');

The problem is that it is not possible to get a return-code if something went wrong within sqlplus. The only return-code to get is the one of the operating-system.

Is there a PL/SQL package which executes the COPY command? Or does someone have a better idea?

Kind regards,

Niek Kerkemeijer. Received on Mon Apr 19 1999 - 15:32:36 CEST