[mgamberi]

I have this script:

import cx_Oracle
connection = cx_Oracle.connect("USER","PASS","ALIAS")
cursql = connection.cursor() 
cursql.execute("select SQL_TEXT,ERROR_MSG from user_resumable")
for column_1,column_2 in cursql.fetchall():
    print "Statement:", column_1," Errore: ", column_2
cursql.close()
connection.close()

I would like to pass the values of user,pass and alias when I execute this script using 3 variables, like this:
python test_connect.py name pass db

I know there is optparse. But I don't know how to use it.

I try with:

from optparse import OptionParser

parser = OptionParser()
parser.add_option('-n',"--nome",action="store")
parser.add_option('-p',"--password",action="store")
parser.add_option('-a',"--alias",action="store")
(options, args) = parser.parse_args()

Now my question:

how can I pass the arguments to the fuction:

connection = cx_Oracle.connect("USER","PASS","ALIAS")

[gaba88]

never used optparse but i guess that you are simply uploading something why dont you try the code from this article.

Enjoy Pythoning
Gaba88