- 论坛徽章:
- 0
|
sql语句在sqlplus里面执行没有问题,放到shell里就这样了报这些错误
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jun 23 18:41:29 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> SQL> SQL> SQL> SQL> 2 SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
USER=afc_business
PASSWORD=afc_business01
SID=mlc_dev
$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWORD}@${SID} <<EOF
set heading off
set feedback off
set serverout on
INSERT INTO BIZ_ACC_TRANSFER_DATA (DATA_TYPE, TRANSFER_TYPE,CREATE_DATE,FILE_NAME,BATCH_ID) VALUES (2,1,'20100622','30098100623172433001A1','751362004E009F9DD1D2214C00000002')
commit;
exit
EOF |
|