Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help: COPY in SQL*Plus
Niek Kerkemeijer wrote on 19-Apr-99 14:42:46:
>Hi,
[...]
> 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.
Hello Niek,
how about piping the output of sqlplus through grep and looking for
'ORA-'? Haven't tested this but it may work.
>Niek Kerkemeijer.
Hope that helps,
Lothar
--
Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de Schulstr. 12 | lothar.armbruester_at_t-online.de D-65375 Oestrich-Winkel |Received on Mon Apr 19 1999 - 15:06:41 CDT