Re: Truncation From Unix Script
From: Dan Daley <Dan_Daley%FEDERAL-MOGUL_at_notesgw.CompuServe.com>
Date: 1996/07/19
Message-ID: <4so2eg$cjb_at_arl-news-svc-1.compuserve.com>#1/1
-Your problem is that you're doing both.
-
Date: 1996/07/19
Message-ID: <4so2eg$cjb_at_arl-news-svc-1.compuserve.com>#1/1
-Do one of
-
- sqlplus sys/password << EOF
- EXECUTE TRUNCATE_TABLE('shraps.receiving_header');
- /
- EOF
-
-OR
-
- sqlplus sys/password << EOF
- begin
- TRUNCATE_TABLE('shraps.receiving_header');
- end;
- /
- EOF
-Your problem is that you're doing both.
-
Thanks,
I took took out the execute and all is well.
Dan Daley Received on Fri Jul 19 1996 - 00:00:00 CEST