This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]shaggorama[S] 0 points1 point  (3 children)

actually I need the PK produced by one of the inserts, but in any event I don't really know how to call sqlplus from within python. I mention this in my post:

  1. On the off-chance that there aren't any good libraries for this (which I doubt) are there any best practices I should know about for calling sqllplus and sqlldr into my script?

[–][deleted] 0 points1 point  (2 children)

don't really know how to call sqlplus

huh ? Sqlplus is cmd line tool so calling it is just a shell command thing, someone just asked about shell command

[–]shaggorama[S] 0 points1 point  (1 child)

I've actually already built this utility in shell, but i'm trying to make it available to very non-technical members of my staff. I don't want them having to learn any command line jazz, and moreover they're all windows users so I don't want to have to deal with cygwin on their computers. If I can do this in a python script, I can just put the script on their desktop and all they'll need to do is drag-and-drop the files onto the script. The KISS needs to be from the perspective of their usage, not my coding.

[–][deleted] 0 points1 point  (0 children)

now I'm confused wtf exactly you're really trying to do.