使用Python的SQl Loader(SQl Loader using Python)

 我看到SQL Loader表现得非常奇怪。 
 
 我在我的终端（Linux）上执行了一个命令 
 
sqlldr username/password@XXXX control=xxx.ctl
 
 上面的命令没有产生任何错误： 
 
Total logical records skipped:          0
Total logical records read:             4
Total logical records rejected:         0
Total logical records discarded:        0 
 
 但是当我在python脚本中使用这个语句时： 
 
subprocess.call('sqlldr USERNAME/PASSWORD3@XXX control=XXX.ctl', shell=True)
 
 我看到没有记录被加载到目标表中： 
 
Total logical records skipped:          0
Total logical records read:             0
Total logical records rejected:         0
Total logical records discarded:        0
 
 关注的是，当我在命令行中运行SQL loader命令时，它表现正常，但不在python脚本中。任何建议请... 
 
 谢谢 

I see that SQL Loader is behaving quite weird.
 
I have executed a command on my Terminal(Linux) as
 
sqlldr username/password@XXXX control=xxx.ctl
 
The above command didnot produces any errors:
 
Total logical records skipped:          0
Total logical records read:             4
Total logical records rejected:         0
Total logical records discarded:        0 
 
but when i used this statement inside python script:
 
subprocess.call('sqlldr USERNAME/PASSWORD3@XXX control=XXX.ctl', shell=True)
 
i see no records are been loaded into the target table:
 
Total logical records skipped:          0
Total logical records read:             0
Total logical records rejected:         0
Total logical records discarded:        0
 
The concern is that when i run the SQL loader command in commandline it behaves normal, but not within the python script.Any suggestions please..
 
Thanks 

原文：https://stackoverflow.com/questions/30026794