Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: COPY in SQL*Plus

Re: Help: COPY in SQL*Plus

From: Lothar Armbrüster <lothar.armbruester_at_rheingau.netsurf.de>
Date: 19 Apr 99 21:06:41 +0100
Message-ID: <622.778T2062T12664317lothar.armbruester@rheingau.netsurf.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US