SQl Loader using Python

Question

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

Gary_W · Accepted Answer · 2015-05-04 14:19:23Z

4

Try this as I believe you need the USERID= before the login info:

subprocess.call('sqlldr userid=USERNAME/PASSWORD3@XXX control=XXX.ctl', shell=True)

answered May 4, 2015 at 14:19

Gary_W

10.4k1 gold badge26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQl Loader using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related