Re: SQLPLUS COPY command

Try putting WHENEVER SQLERROR EXIT 5
into the script. This will exit with OS value 5 if any error occurs.

Regards

Kugendran Naidoo
Independant Oracle DBA

Niek Kerkemeijer wrote:

> Hi,
>
> 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 Tue Apr 20 1999 - 13:28:11 CEST