Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import urllib
- import requests
- from bs4 import *
- from subprocess import Popen,PIPE
- import os
- connectString = 'SYSTEM/mediadot123'
- def runSqlQuery(sqlCommand, connectString):
- session = Popen(['sqlplus', '-S', connectString], stdin=PIPE, stdout=PIPE, stderr=PIPE)
- session.stdin.write(sqlCommand)
- return session.communicate()
- session = Popen(['sqlplus','-S','hr/hr'], stdin=PIPE, stdout=PIPE, stderr=PIPE)
- stdout, stderr = session.communicate()
- sqlCommand = "insert into food(title, recipe, image) values ('bla','bla','bla');"
- queryResult, errorMessage = runSqlQuery(sqlCommand, connectString)
- print queryResult
- C:Python27python.exe C:/Users/Umer/PycharmProjects/DATACRAWLER/main.py
- Traceback (most recent call last):
- File "C:/Users/Umer/PycharmProjects/DATACRAWLER/main.py", line 38, in <module>
- session = subprocess.Popen(['sqlplus','-S','hr/hr'], stdin=subprocess.PIPE, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
- File "C:Python27libsubprocess.py", line 710, in __init__
- errread, errwrite)
- File "C:Python27libsubprocess.py", line 958, in _execute_child
- startupinfo)
- WindowsError: [Error 2] The system cannot find the file specified
- Popen(['C:/path/sqlplus.exe', '-S', ...])
- print(os.environ['PATH'])
Add Comment
Please, Sign In to add comment