我目前有以下功能,我知道当我通过GUI SQL Client手动运行输出的查询时,它可以工作,但在Bash中它不能工作。。。
我尝试了我能想到的一切,并用谷歌搜索了我能想出的关键词。。
AssignChunksToDocs()
{
TEST="set heading off;
set trim on;
DECLARE
i number;
BEGIN
i := 1;
while i<=$CHUNK_AMOUNT LOOP
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL
AND ROWNUM <=$DOCS_PER_CHUNK;
i := i+1;
END LOOP;
i := i-1;
-- Deal with the remainder
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL;
end;"
sqlplus -s $CONSTR<<ENDOFSQL
set heading off;
set trim on;
DECLARE
i number;
BEGIN
i := 1;
while i<=$CHUNK_AMOUNT LOOP
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL
AND ROWNUM <=$DOCS_PER_CHUNK;
i := i+1;
END LOOP;
i := i-1;
-- Deal with the remainder
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL;
end;
ENDOFSQL
ERRORCODE=$?
if [ $ERRORCODE != 0 ]
then
echo "********************"
echo "ERROR: The SQL Plus Command Failed. ErrorCode: $ERRORCODE"
else
echo "********************"
echo "SQL Plus Successfully Ran. ErrorCode: $ERRORCODE"
fi
}
当我运行它(在shebang中使用-x)时,得到以下代码片段:
+ AssignChunksToDocs
+ TEST='set heading off;
set trim on;
DECLARE
i number;
BEGIN
i := 1;
while i<=
64 LOOP
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL
AND ROWNUM <=3;
i := i+1;
END LOOP;
i := i-1;
-- Deal with the remainder
UPDATE TABLE T SET T.CHUNK_NUM = i
WHERE T.CHUNK_NUM IS NULL;
end;'
+ sqlplus -s dbuser/dbpass@hostname/sidname
+ ERRORCODE=0
+ '[' 0 '!=' 0 ']'
+ echo '********************'
********************
+ echo 'SQL Plus Successfully Ran. ErrorCode: 0'
SQL Plus Successfully Ran. ErrorCode: 0
在终端命令行中手动测试查询也会发生同样的情况,然后手动粘贴<&书信电报;SQL…SQL块。
请帮助:)