Hei Alle,

OS: AIX 5.3

Jeg bruker følgende shell script for oppdateringen søket, men ikke får spørsmål om å angi verdier for '& From_date "og" & TO_Date "i oppdateringen søket når synte fra shell script som følger:

patch_query.sh
\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d

#! / usr / bin / ksh

eksport DBALIST \u003d "xyz@xyz.com"
export USER \u003d apps
eksport PWD \u003d******
export SID \u003d XYZ

sqlplus "$ USER / $ PWD" <<!
@ patch_query.sql
exit
!
if [ `cat patch_query.alert | wc-l`-gt 0]
så
cat patch_query.alert-l patch_query.alert> patch_query.tmp
mailx-s "Patch Query varsel for $ (SID)" $ DBALIST <patch_query.tmp
fi

patch_query.sql
\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d

satt strømmen av
set linesize 100
satt pageSize 200
spole patch_query.alert
velger BUG_NUMBER "PATCH_NUMBER", to_char (creation_date, 'DD-MMM-ÅÅÅÅ HH24: MI: SS') CREATION_DATE fra ad_bugs
der to_char (creation_date, 'DD-MMM-ÅÅÅÅ HH24: MI: SS') mellom '& From_date "og" & TO_Date';
spole off;

Feilmelding:
\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d


$ / Home / oraxyz $. / Patch_query.sh

SQL * Plus: 10.2.0.3.0 Release - Produksjonen på Tir Okt 7 08:16:25 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Koblet til:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
Med partisjonering, OLAP og Data Mining alternativer

SQL> Angi verdi for from_date: Angi verdi for to_date:
Bruker valgte Avbrudd eller EOF oppdaget.
SQL> Koblet fra Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Produksjon
Med partisjonering, OLAP og Data Mining alternativer
cat: 0652-050 Cannot open-l.
$ / Home / oraxyz $

kunne noen behage utleie meg vite hvor å gjøre det?

Takk for tiden din!

Hilsen,